Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Wildcard Problem
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