How to put conditional where clauses? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

How to put conditional where clauses?

Message

De

17/12/2007 04:07:08

Christof Wollenhaupt
Foxpert
Norderstedt, Allemagne

À

17/12/2007 03:59:25

Joaquim Correia
B2B, Lda
Portugal

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Syntaxe SQL

Titre:

Re: How to put conditional where clauses?

Divers

Thread ID:

01276215

Message ID:

01276217

Vues:

25

Hi,

I would use something like:

case when a.selection = '1' then a.type1 else b.type2 end

--
Christof

Click here to load this message in the networking platform