Hello,

Is it possible to create a new SQL statement, lets call it modify, such
that I can do the following in one statement?

MODIFY
CASE
WHEN B=1 THEN UPDATE PTR_POSITION SET C=2 END
WHEN B=5 THEN DELETE PTR_POSITION END
WHEN B=7 THEN UPDATE PTR_POSITION SET C=2 END
WHEN B=9 THEN INSERT INTO TABLE_B VALUES("1","2") END
FROM TABLE_A
WHERE COL_A = "something"

Thanks,
Ryan Putnam