Filtering out an asterisk in text

[SerenityNet]

I have a database where the "Item" field sometimes contains item codes with an asterisk as the first character. I want to filter out all item codes that begin with an asterisk, but for the life of me I can't figure out how.

Any help will be greatly appreciated.
Andrew

 

[SerenityNet]

answer

Got it!

SELECT Table1.item, Table1.date
FROM Table1
WHERE (((Left([table1].[item],1))<>'*'));