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: Mon, 23 Oct 2006 08:09:16 -0700
Message-ID: <1161616154.929156@bubbleator.drizzle.com>


harry_johnson_4_you_at_yahoo.com wrote:
> William,
>
> Asking me how char(7) could be two character clued me in. The
> application is inserting spaces after the values. So if my values are
> 44, then it's adding 5 spaces to the end and that what it is. When I
> ran the query
>
> Select * from myDB where column1 like '4______' (6 underscores)
>
> It finally returned data, but it returned everything. When I run
>
> Select * from myDB where column1 like '4_ ' (5 spaces)
>
> I get exactly what I want.
>
> I appreciate all of the suggestions.
>
> Thanks for yoru help.

If you possibly can ... change the CHAR to VARCHAR2. Many things will run better.

-- 
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 Mon Oct 23 2006 - 10:09:16 CDT

Original text of this message

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