Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Query problem

Re: Query problem

From: Tom Stearns <tom_at_stearns.com>
Date: 2000/05/31
Message-ID: <_bdZ4.633$bR5.15856@news.uswest.net>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US