Hi all,

Is it possible using sql to select records where the first letter of a field equals a given value?

cheers
Steve

If it's access, I know Select Fields from Table where Left (Field_Name, 1) = 'A' works.

Easy to do using LIKE in your where clause. For example, if you want to return the records in a given table where the "Name" field value for that record starts with 'M', you'd do something like:

SELECT * FROM users WHERE name LIKE 'A%'

% is a wild card. SO you could do '%ING' to get everything ending in ING, or '%RT%' to get everything that has 'RT' anywhere in it, etc.