Not for Microsoft SQL Server.  That is handled entirely by the collation
setting.  (Please, somebody prove me wrong! Sometimes I face the same
problem, and I've never found a way.)

Eric



[EMAIL PROTECTED]
02/03/2004 11:42 AM
Please respond to sql

        To:     SQL <[EMAIL PROTECTED]>
        cc:
        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]

Reply via email to