question about SQL statement

[hotsauce]

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!

[paulw]

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.