Hello all,

I need a sql querie that returns some rows like this:

select a.id, a.name, a.type, a.type1, a.type2, a.selection where a.type = (case a.selection = '1' a.type1 else b.type2 end)

or

select a.id, a.name, a.type, a.type1, a.type2, a.selection where a.type = iif(a.selection = '1', a.type1, b.type2)

I know thar 'iif' is not permited in Sqlsrvr, on the other hand it seems that i can't use 'case else end' in a where condition, so how to acomplish a mission like this?

Thank you all,
Joaquim