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
