use the LIKE keyword
~Simon
> Simon Horwith
> Allaire Certified Instructor
> Certified ColdFusion Developer
> Fig Leaf Software
> 1400 16th St NW, # 220
> Washington DC 20036
> 202.797.6570 (direct line)
> www.figleaf.com
>
-----Original Message-----
From: DSJ / PC1, Inc. [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 19, 2001 2:15 PM
To: CF-Talk
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
