-
I am trying to do a WHERE/LIKE clause with a wildcard. I read in a book to use the '*' operator. It didn't work. Example:
Select * FROM KaraokeList WHERE KaraokeList.Title LIKE 'A*'
I worked on it for a few hours and then tried the '%' operator. It finally worked. Example:
Select * FROM KaraokeList WHERE KaraokeList.Title LIKE 'A%'
Can anyone tell me why the '*' didn't work but the '%' did. Everywhere I've read tells me to use the '*'. Thank you very much!
-
Presumably you are in SQL Server - % is the wild card char in SQL Server whereas Access and ADO use *. It is application specific.
Cheers,
P.
