[AccessD] Querying by Upper or Mixed Case

Thanks. After futher speaking to the client, that is pretty much what we did is 
run an update query to make all the values upper case.




________________________________
From: Doris Manning <mikedorism at verizon.net>
To: Access Developers discussion and problem solving 
<accessd at databaseadvisors.com>
Sent: Tue, July 13, 2010 6:39:17 AM
Subject: Re: [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


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