SELECT LIKE PROB 1

[klornpallier]

I need to COUNT the number of 'employees' that have 'forenames' beginning with M AND A but the query below dont work. Please help

SELECT COUNT(forenames) FROM employee
WHERE forenames LIKE 'M%'
AND LIKE 'A%'

 

[PHV]

With begin with MA:
SELECT COUNT(forenames) FROM employee
WHERE forenames LIKE 'MA%'
With begin with M or A:
SELECT COUNT(forenames) FROM employee
WHERE forenames LIKE 'M%' Or forenames LIKE 'A%'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[klornpallier]

BRILLIANT THANK YOU