Problem with "Like"

hi guys.

I'm trying to create an access statement to find all rows that have an item name which begins with a specific character. For example, if I want to find all items beginning with the letter "E" then my statement I would think should look like this:
select * from products where prodname like '%E' order by prodname asc

Unfortunately though, that doesn't seem to be working. I've also tried changing the '%E' portion to both 'E' and '%E%' but I'm never able to retrieve any rows.

Any idea what I'm doing wrong?

thanks in advance.

-Goalie3533

Access uses a different wildcard character - can't remember what it is off-hand, but it has been discussed here repeatedly in the last few weeks - do a search - or read the Access help - it gives several examples.

select * from products where prodname like 'E*' order by prodname asc