Re: Wildcard Problem

From: <harry_johnson_4_you_at_yahoo.com>
Date: 19 Oct 2006 05:24:52 -0700
Message-ID: <1161260692.094278.43820@m73g2000cwd.googlegroups.com>

I tried

select *
from mydb
where length(column1) = 2
and substr(column1,1,1) = '4'

but it didn't work. It still returned nothing, not even an error.

Since this database was created by our vendor, I wasn't exactly sure what the column was. Documentation lists it as char. I tried to do this on a different table and it worked fine.

select * from myTable2 where column1 = '36___' pulled exactly what I wanted as well as the other query when I used it on a different table.

For some reason, it doesn't work on the table that contains the data I need. Received on Thu Oct 19 2006 - 07:24:52 CDT