Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Case sensitive selection in case insensitive database
Message
De
30/04/2007 14:39:55
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Case sensitive selection in case insensitive database
Divers
Thread ID:
01221228
Message ID:
01221228
Vues:
55
Our SQL SERVER is set for case insensitive. But we need to do the case sensitive selection. For example, we have a field called Letters. In this field, we have 'ABCD', 'AbCd', 'ABCd', 'ABCD','abcd'. We only need select the record having this field ='AbCd'.

How can we write this SQL selection?

Regard

Jim
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform