Tuesday, 27 August 2013

How to select rows with the same criteria in multiple columns?

How to select rows with the same criteria in multiple columns?

Will there be any other ways instead of writing the same criteria multiple
times?
SELECT * FROM tblEmployees E
WHERE E.CurrentAddress LIKE '%dan%' OR
E.Email1 LIKE '%dan%' OR
E.Email2 LIKE '%dan%' OR
E.LatinName LIKE '%dan%'

No comments:

Post a Comment