[AccessD] Querying by Upper or Mixed Case

I would strongly suggest that you can use UPPER to transform the contents of
the field and the search request.

Doris Manning


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lonnie Johnson
Sent: Sunday, July 11, 2010 6:50 PM
To: AccessD solving'
Subject: [AccessD] Querying by Upper or Mixed Case

Just curious,

Is there a way to search or match a string that is just upper case or mixed 
case? I have a filed that has these two values and the customer actually
wants 
to be able search for just one of the two. The two values are...

2010 ACTUALS

2010 Actuals


      
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com