That doesn't solve anything at all, what I am wanting to do is get a match
where ColumnName is 'Test Query' and NOT 'TesT Query'. Your solution would
pull both of those from the db, doesn't solve the case sensitive issue at
all.
Bernd VanSkiver
[EMAIL PROTECTED]
ColdFusion Developer
----- Original Message -----
From: "Nilufer Basagaoglu" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, August 30, 2001 4:44 PM
Subject: RE: case sensitive sql query
>
> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
