Finding records with respect to casing

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Finding records with respect to casing

Message

08/03/2009 22:47:47

08/03/2009 16:05:24

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Syntaxe SQL

Titre:

Versions des environnements

SQL Server:

SQL Server 2008

Application:

Web

Divers

Thread ID:

01386512

Message ID:

01386547

Vues:

>>select * from member 
>>  where City = 'Petit-Rocher' 
>>   AND  City COLLATE SQL_Latin1_General_CP1_CS_AS = 'Petit-Rocher'
>>

>
>Thanks, this works.

You're welcome.

--sb--