Try
<cfset theText = 'Test Query'>
SELECT ColumnName
FROM tableName
WHERE upper(ColumnName) = #ucase(theText)#
-----Original Message-----
From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 2:00 PM
To: CF-Talk
Subject: case sensitive sql query
Is there a way to do a case sensitive SELECT query? Don't want to make
a
server wide change, just want to specify a single query to do a case
sensitive search.
SELECT ColumnName
FROM tableName
WHERE ColumnName = 'Test Query'
Want this to do a case sensitive search on the WHERE clause.
Bernd VanSkiver
[EMAIL PROTECTED]
ColdFusion Developer
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
