Browse by letter

[Anon]

Hello,
I am making an application, that will browse items from a DB. I need to select all records that start with a certain letter. Is there a SQL call that can do this? I have tried code, but i think it would be more efficient if I can do it with an SQL call.
Thanks,

Bill
http://www.freephpstuff.com

[toma42]

select * from sometable where some_column like 'a%';

where a = [a-z]