According to my calculations, all major databases support the replace() function, except for Sybase ASE, which has a similar function named str_replace(), and Derby.

I think it would be useful to add it to the spec. The signature would be String replace(String string, String pattern, String replacement).