SQL(Access) ignore/convert case?

by Jake <ijake(at)iname.com>

Date:	Mon, 30 Oct 2000 18:54:14 -0500
To:	hwg-languages(at)hwg.org
	todo: View Thread, Original

In my table I have a value for name 'VanHam'
SELECT name FROM tablename WHERE name LIKE '%Vanham%'
will not retrieve the record.

SELECT UPPER(name) FROM tablename WHERE name LIKE '%VANHAM%'
works with ORACLE, unfortunatlly I'm using ACCESS

Help!

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA