I commented the code that does not make any sense (actually will fail if run).
BEGIN
UPDATE CNMPNT SET
CUSTOMER_ALPHA=@ChangeAlphaPoiner
WHERE
CUSTOMER_ALPHA=@aplhaPointer AND
ltrim(Rtrim(replace(CUSTOMER_ID,char(0),''))) IN (@CustomerIDs)
UPDATE CMAPNT SET
CUSTOMER_KEY=@ChangeAlphaPoiner
WHERE
CUSTOMER_KEY=@aplhaPointer AND
ltrim(Rtrim(replace(CUSTOMER_ID,char(0),''))) IN (@CustomerIDs)
UPDATE CUSMAS SET
ALPHA_POINTER=@ChangeAlphaPoiner
WHERE
ALPHA_POINTER=@aplhaPointer AND
ltrim(Rtrim(replace(cust_id,char(0),''))) IN (@CustomerIDs)
END
Would this work for you?