Which to use, Nested Case or Nested If? 1

[awholtsIT]

Not sure the best practice for accomplishing this requirement in a select query;

I want to query FIELD 1 in Table A
if FIELD 1 = ABC then
query another field for it's value
if FIELD 2 = XYZ then 2
else - 2
else 0

the result of this query should be placed into another field through a "as [new field name]" in that same Table A

Can someone help me with the proper syntax for this?

Thanks,

Andrew

 

[markros]

case when Field1 = 'ABC' then case when field2 = 'XYZ' then 2 else -2 end else 0 end

 

[awholtsIT]

That worked perfectly.

Many Thanks!!

Andrew

 

[markros]

You're welcome.