REPLACE

REPLACE(string, searchString [, replacementString])

Description

Replaces all occurrences of a search string in a text with another string. If no replacement is specified, the search string is removed from the original string. If any parameter is null, the result is null.

Examples

SELECT REPLACE(NAME, ' ') FROM Players;