Using CASE WHEN in SQL Select

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Using CASE WHEN in SQL Select

Message

14/08/2011 18:30:18

14/08/2011 18:17:13

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Syntaxe SQL

Titre:

Versions des environnements

SQL Server:

SQL Server 2005

Divers

Thread ID:

01520963

Message ID:

01520981

Vues:

>>CASE when MyTable.Log_Fld = 1 THEN 0 ELSE 2 END as NewFldName

>>
>>Using bit field it's either 1/0 or 'true'/'false'
>
>Thank you very much!

You're welcome.

If it's not broken, fix it until it is.

My Blog