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!