I would think that it should work fine with commas, if it were between a pair of apostrophes SQL should know that it is part of a string. Hell, maybe that really is the way that it works, and I ...

I'd like to know that a NULL is going to be inserted into a non-nullable field on one row via RAISEERROR, skip that row's update, and then allow the SQL statement to continue.

Learn how to master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier.