try UPPER on your variable in your query
----- Original Message -----
From: "DSJ / PC1, Inc." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, February 19, 2001 1:15 PM
Subject: Querying a db with all caps
> Hello All,
>
> I am querying a database that uses only capital letters in all of the
values
> inside each field. When I perform a search using smaller case letters,
> nothing shows up, however, when I type in ALL CAPS in my search, it works
as
> expected.
>
> Now, my question is, is there a way that I can make my query work even if
> someone uses all smaller case letters in the search field?
>
> Any help would be greatly appreciated here.
>
> Thanks,
>
> DSJ
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
