Nested IF in Select

[sqlturbo]

Can I use a nested IF condition in a Select query? I want to query different columns in the same table depending on what is the value of the given attribute.

The psuedo code for the query looks like

Select colA, colB,
(If colC > 0 then colD
Else (if ColE>0 then ColF
Else (if ColG > 0 then ColH)))
From TableName.

Thanks.

 

[maswien]

try:

Select colA, colB,
case when colC > 0 then colD
Else ( case when ColE > 0 then ColF
Else (case when ColG > 0 then ColH end)
end)
end
From TableName.

 

[r937]

i prefer not to nest them, it makes for cleaner sql

and i always code the "else null" because, well, just because

select colA
     , colB
     , case when colC > 0 then colD 
            when ColE > 0 then ColF 
            when ColG > 0 then ColH 
            else null
        end
  from TableName

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)

 

[donutman]

rudy, the right answer was "just in case."
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[r937]

LOL



rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)

 

[sqlturbo]

Thanks guys. That worked.