Expecting something between ')' and the 'AS' keyword

132 views Asked by At

I am trying to run the update query below in Teradata but getting an error message 'Expecting something between ')' and the 'AS' keyword. I am missing anything? I have checked some previous update and it worked for other developers in my company.

 WHEN MATCHED THEN UPDATE SET


 PRSCRBR_LAST_NM = COALESCE(M.PRESCRIBER_LAST_NAME,'ZZZZ1') AS PRSCRBR_LAST_NM,

Thanks

0

There are 0 answers