SUBSTITUTE

Name

SUBSTITUTE —
SUBSTITUTE(text, old, new [,num])

Description

Replaces @old with @new in @text. Substitutions are only applied to instance @num of @old in @text, otherwise every one is changed.

See also

REPLACE , TRIM