Get Team Site List by Title 07 May 2011 Administrator SharePoint2003, SharePoint2003 (0) It’s very simple tip but it helped me a lot cause the Korean Air has lots of sites. SELECT TOP 20 * FROM Webs WITH (NOLOCK) WHERE Title LIKE N'{TeamSiteName}%'