I'm trying to get some consistency in the contents of a field in a
table. To do so involves multiple updates using REPLACE.

Is it acceptable to make multiple calls to replace involving the same
field in a single update operation, like so:

UPDATE audio SET
    composer = REPLACE( composer, " / ", "\\" ),
    composer = REPLACE( composer, " , ", "\\" ),
    composer = REPLACE( composer, ", ", "\\" ),
    composer = REPLACE( composer, ",", "\\" ),
    composer = REPLACE( composer, "\\Jr.\\", ", Jr.\\" ),
    composer = REPLACE( composer, "\\Jr\\", ", Jr.\\" )
;

Reply via email to