[AccessD] Querying by Upper or Mixed Case

Lonnie Johnson prodevmg at yahoo.com
Tue Jul 13 08:16:50 CDT 2010


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



      


More information about the AccessD mailing list