Re: tricky query

[Stephen Counsell]

Hi,

Should be fairly simple, try this:

select * from members where lastname LIKE 'a%'
gets all the records where the lastname begins with 'a'

select * from members where lastname LIKE 'b%'
gets all the records where the lastname begins with 'b'

select * from members where lastname LIKE 'z%'
gets all the records where the lastname begins with 'z'

Hope that helps

regards
Steve