Eugene Elutin (11/29/2012)
Try this:
SELECT S.CityId, C.Name
FROM @City AS S
CROSS APPLY (VALUES (CityName),(AlternateCityName1),(AlternateCityName2)) C(Name)
WHERE C.Name LIKE @SearchString + '%'
Thanks Eugene..never known we can use Cross Apply in this way.