Take a standard broad search query...:
DECLARE @sq Varchar(50) = 'Desperate'
SELECT *
FROM [UnbelievablyHotWomenOrAtLeastAcceptable] u
WHERE
u.Address LIKE '%' + @sq + '%' OR
u.City LIKE '%' + @sq + '%' OR
u.firstname LIKE '%' + @sq + '%' OR
u.Lastname LIKE '%' + @sq + '%' OR
u.Email LIKE '%' + @sq + '%' OR
u.Notes LIKE '%' + @sq + '%'
Is there a way to make that query less of a copy+paste effort?
Something along the lines of
...WHERE (u.Address OR u.City OR u.firstname OR u.Lastname OR u.Email OR u.Notes) LIKE '%' + @sq + '%'
I know if I use full text search, CONTAINS and CONTAINSTABLE offers me a syntax for querying all columns in the table, that are in the full text catalog at once, but that is not what I am looking for.