and clause in query

[ERUM]

hi to every one

can I put insert and in case clause of sql server ?? like




case 'M' and tx>0 then 'Good'

[digitalShaman]

i am not sure what you mean with 'insert'. Insert statement?
if you just ask for a combination of conditions within a case when construct then this should do what you ask for:

case when (field=M and tx>0) then 'Good' else 'Bad' end

note that this is different from

case field when 'M' then 'Good' else 'Bad' end

the latter one is similar to a select case in vb where you have one value and match it with different possibilities while the first one is more like a if (..) elseif (..) construct where you can check for different things in each if

[techgnome]

The short answer is no... if you need compound cases like that, it all needs to be moved down into the when clause as digitalshaman has shown.

-tg