Query problem

Hi!

I want to generate a list of names. The condition is the first letter of the last name.

My query looks like this:

Select userid,lname,fname, telno, substring(lname,1,1) AS FLetter from <TABLE>
where Fletter = '<Letter'>.

It doesn't work, saying I have a syntax error near my 'where clause'.

Can anyone help me?

Alesk Received on Wed May 31 2000 - 00:00:00 CDT