Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query problem
WHERE lname like '<Letter>%'
should do the trick. You can substring(...) as FLetter too.
Tom Stearns
"Alesk" <alesk_at_enter-net.com> wrote in message
news:wYbZ4.386$WL3.90794_at_carnaval.risq.qc.ca...
> 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
![]() |
![]() |