Need help with Case-sensitive queries in SQLServer 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to retrieve records just as they are and enforce case-sensitivy. For
example, my query return 'E1234' in place of 'e1234'. I want to return
exactly what is in the table.

How do I do that?

Thnaks
mo
 
Short of using a case insenstive DB you could use the collate clause :

IF 'e1234' COLLATE FRENCH_CS_AS='E1234' COLLATE French_CS_As
PRINT '='
ELSE
PRINT '<>'

By "retrieving", I suppose you mean there is a problem in the where clause,
now in the retrieved value (lese you likely have some formatting taking
place)...
 
Back
Top