Use compare()
Shawn Regan
Applications Developer
Pacific Technology Solutions
-----Original Message-----
From: Nilufer Basagaoglu [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 3:08 PM
To: CF-Talk
Subject: RE: case sensitive sql query
This depends on the database you use.
Oracle's result would be only 'Test Query' not 'TesT Query'.
What is your database?
-----Original Message-----
From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 2:54 PM
To: CF-Talk
Subject: Re: case sensitive sql query
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
