part of a field

[northernbeaver]

Im having a problem with the LIKE() function. I have a field with product descriptions. I want people to be able to type in a word and have it search the description field that has the word they typed in. Im even trying to hard code it at this point in time and nothing will come up.

SELECT tblPrice.Description, tblPrice.*
FROM tblPrice
WHERE (((tblPrice.Description) Like '%USB%'));


is what Im using and nothing is coming up. I have searched through the table and I know that the word USB exsists in the description field in about 10 records....but nothing. to frustrated to think right now, any help on something that should be simple should be greatly appreciated.

 

[kevinclark]

For Access I believe the wild character is *

SELECT *
FROM tblPrice
WHERE Description Like '*USB*'