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: <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

Original text of this message

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