Re: Wildcard Problem

From: <harry_johnson_4_you_at_yahoo.com>
Date: 23 Oct 2006 07:56:30 -0700
Message-ID: <1161615390.173269.241220@m73g2000cwd.googlegroups.com>

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. Received on Mon Oct 23 2006 - 09:56:30 CDT