Select all vrom db where first character is X

[Pheddy]

Hey everybody!

I need a code to select all (*) from my databse (.mdb - microsoft access) where first letter i X.. how can I do this?


Thanks.
Frederik

[jhardman]

SELECT * FROM myTable WHERE fieldName LIKE 'X%'