Convert Access quey to SQL statement

[rparcha]

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"," "))))))



MY SQL STATEMENT:
Testx = CASE
WHEN SUBSTRING([ITMaster].[Section],1,2) = 'AB' AND
SUBSTRING([ITMaster].[MastPlanFam],1,3)<>'XYZ' THEN 'M'
WHEN [ITMaster].[Center] = '1111' THEN 'A'
WHEN [ITMaster].[Center] = '2222' THEN 'C'
WHEN [ITMaster].[Center] = '3333' AND
[ITMaster].[Vendor] = 23456 THEN 'A' ELSE 'B'
WHEN [ITMaster].[Sop] = 'ABC' THEN 'Z' ELSE '' END

UP TO HERE IT WI WORKING FINE

[ck9663]

Looks like you have 2 "ELSE"

-- CK