WHERE query problem

[PegasusT4]

Hi,
I need a WHERE statement that does the following:

WHERE LEFT(name,1) IN 'abcdef'

i.e. I want to see if the first letter in name field is in the 'abcdef'
string, and if it is, return that record.

Any help is greatly appreciated.

Thanks

[The ScareCrow]

This will depend upon the db your using, so you may need to find out if your db
has the left function, from memory ms access does. You then need to format the
list so that it is a qualified comma seperated list

WHERE LEFT(name,1) IN ('a','b','c','d','e','f' )

Ken