How to put conditional where clauses? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

How to put conditional where clauses?

Message

From

17/12/2007 04:07:08

Christof Wollenhaupt
Foxpert
Norderstedt, Germany

To

17/12/2007 03:59:25

Joaquim Correia
B2B, Lda
Portugal

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Re: How to put conditional where clauses?

Miscellaneous

Thread ID:

01276215

Message ID:

01276217

Views:

26

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