how would i write a query that gets a table with names that only begin with the letters a-c. select * from agency where agency_name=[what?]
select * from table where lower(agency_name) like 'c%'
should work.
