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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Wildcard Problem

Re: Wildcard Problem

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 18 Oct 2006 20:09:17 +0200
Message-ID: <eh5q8b$37u$2@news6.zwoll1.ov.home.nl>


harry_johnson_4_you_at_yahoo.com schreef:
> No '4%' works as expected so I get all of the records where column1
> begins with 4, but it gives me too many, so I get records I don't want,
> like 444, 44777
>
> I just want records that begin where column one is only two characters
> 4 and something else
>

Is it a varchar, varchar2 or char column?

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Wed Oct 18 2006 - 13:09:17 CDT

Original text of this message

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