not case-sensitive:
We are using this:
SELECT *
FROM table
WHERE (CAST(column AS varbinary(12)) = CAST('#comparevalue#' AS
varbinary(12)))
This should work for you, at least in SQL SERVER 7.0 and 2000
Stefan
Dr. Stefan Salzbrunn
Geschäftsführer
--------------------------------------------------------
InterLake - The Web Enabler
Friedrichshafen München Berlin New York
--------------------------------------------------------
InterLake Informationssysteme GmbH
Postfach 2269
D-88012 Friedrichshafen
Tel 0800 555 1010 (Intl.+49 89 53886562)
Fax 0800 555 1011 (Intl.+49 89 53886573)
E-Mail [EMAIL PROTECTED]
www.interlake.net www.moremx.com www.shadomx.com
--------------------------------------------------------
> -----Original Message-----
> From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, February 03, 2004 11:42
> 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]
