Wildcard Problem

From: <harry_johnson_4_you_at_yahoo.com>
Date: 18 Oct 2006 06:19:25 -0700
Message-ID: <1161177564.988953.156380@h48g2000cwc.googlegroups.com>

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. Received on Wed Oct 18 2006 - 08:19:25 CDT