I am doing a coldfusion SQL query and want to determine if the first letter of a title is A-F, G-M, N-R, S-Z. My query below gives me an error. Also I should make it into Uppercase before I compare but haven't tried that yet either. What would be the best way to do this? Thanks.
<cfquery name="getAF" dbtype="query">
select ID, Title
where left(Title,1) like ([A-F])
order by Title