Hi,

The following is my SQL statement. How can I change from Like to not like?
Therefore it can search other combination except "la".

SELECT * FROM Persons WHERE FirstName LIKE '%la%'


Many Thanks,
Man

Just change LIKE to NOT LIKE and your query will return the records that do not contain 'la'.

Edited by - mm-ultradev on 11 Jun 2002 11:25:39

Thanks!
Work Fine