Re: Wildcard Problem

harry_johnson_4_you_at_yahoo.com schreef:

> I am trying to write a simple query to pull data from a database where
> a column has data that starts with a 4 and is only 2 characters long.
>
> I thought the query would be:
>
> Select * from myDB where column1 like '4_'
>
> When I run the query, it returns nothing. I get no error message, just
> no data.
>
> I do get data if I run the following query:
>
> Select * from myDB I can clearly see that column one contains values
> like 40, 45 etc
>
> This field is a string field but almost alway contains numbers. Not
> sure if that makes a difference.
>
> Thanks for any help.

Does Select * from myDB where column1 like '4%' result in the same? Received on Wed Oct 18 2006 - 09:27:00 CDT