when you do your query do
where upper(field)='BLAH'
if you are using SQL or Sybase
Bill Wheatley
Director of Development
AEPS INC
Allaire ColdFusion Consulting Partner
Allaire Certified ColdFusion Developer
http://www.aeps.com
ICQ: 417645
http://www.aeps2000.com
954-472-6684 X303
IMPORTANT NOTICE:
This e-mail and any attachment to it is intended only to be read or used by
the named addressee. It is confidential and may contain legally privileged
information. No confidentiality or privilege is waived or lost by any
mistaken transmission to you. If you receive this e-mail in error, please
immediately delete it from your system and notify the sender. You must not
disclose, copy or use any part of this e-mail if you are not the intended
recipient. The RTA is not responsible for any unauthorized alterations to
this e-mail or attachment to it
----- Original Message -----
From: "DSJ / PC1, Inc." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, February 19, 2001 2: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
