DB is set to ignore case.
Ray Thompson
Tau Beta Pi ( <http://www.tbp.org/> www.tbp.org)
The Engineering Honor Society
865-546-4578
_____
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 03, 2004 11:42 AM
To: SQL
Subject: Case sensitive compare
Is there a SQL function which will do a case sensitive compare between a DB
value and a passed in value (CFMX)? I don't want to set the entire server to
case sensitive. I just need it for a single query.
I'm doing the case compare outside the query at the moment but I want it as
tight as possible.
Thanks
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
