Re: Wildcard Problem

harry_johnson_4_you_at_yahoo.com skrev:
> 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.

does a "select * " work?
The syntax seems ok. It worked on my tables. Received on Thu Oct 19 2006 - 07:47:22 CDT