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