query to pull records that have first letter A

[BWWebDesigns]

quick question

how would i code a query to select records from a database in the following way

i want it to pic records that have the field lname with a value whos first letter is A

so if its value was abbot or allen or armstrong it would get selected

so i can pull only the names from database that begin with A

anyone able to help

thanks

[chazzy]

select * from table WHERE column like 'A%' or column like 'a%';

[BWWebDesigns]

great thanks

i knew it would be something simple