Case Inside a Case

[Alec]

Hi, I am using the following script but I am getting errorWould you please help me figuring out what's wrong Case WHEN C.#COTYP = 'LA' THEN CASE WHEN C.#COFBD = H.#SOEDT THEN (I.#SISLS * C.#CONPY) ELSE 0 END WHEN C.#COTYP = 'LZ' THEN (I.#SISLS * C.#CONPY)// WHEN C.#COTYP = 'LS' THEN (I.#SISLS * C.#CONPY)// WHEN C.#COTYP = 'MA' THEN (I.#SISLS * C.#CONPY) // WHEN C.#COTYP = 'MD' THEN (I.#SISLS * C.#CONPY)// WHEN C.#COTYP = 'MM' THEN (I.#SISLS * C.#CONPY)// WHEN C.#COTYP = 'MP' THEN (I.#SISLS * C.#CONPY)Else I.#SISLSEND AS SALESPRICE, Thxs

[justsomeguy]

What's the error? Which database are you using?