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: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 18 Oct 2006 09:47:23 -0700
Message-ID: <1161190038.603174@bubbleator.drizzle.com>


harry_johnson_4_you_at_yahoo.com wrote:
> 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

Make sure you have an underscore and not a dash. What you describe is not something I have ever seen.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Oct 18 2006 - 11:47:23 CDT

Original text of this message

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