Rather, that is to say... case-insensitive....
If that's the situation, you could pass your string to a stored procedure
and loop through the string to create a dynamic SQL statement getting the
ASCII codes and setting the appropriate substring criteria along the way...
then execute the statement at the end....
-----Original Message-----
From: Correa, Orlando (ITSC) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 4:50 PM
To: CF-Talk
Subject: RE: case sensitive sql query
If the database has been set up to do case-sensitive searching only you may
have to get into something ugly like comparing individual ascii codes...
For example...
SELECT ColumnName
FROM tableName
WHERE ascii(LEFT(ColumnName,1)) = 84
AND ascii(SUBSTRING(ColumnName,2,1) = 101
etc.. etc...
I'd guess the overhead would be heavy....
Orlando
-----Original Message-----
From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 3: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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
