How to convert following MS access quey to SQL server statement
ACCESS:
Testx: IIf(Mid(dbo_ITM aster!City,1,2) ="AB",IIf(Mid(d bo_ITMaster!Pla n,1,3)<>"XYZ"," M",IIf(dbo_ITMa ster!Center="11 11", "A", IIf(dbo_ITMaste r!Center="2222" ,"C",IIf(dbo_IT Master!Center=" 3333",IIf(dbo_I TMaster!Zip=234 56,"A","B"),IIf (dbo_ITMaster!S op="ABC","Z","...