REPLACE « String Functions « SQL Server / T-SQL






1.REPLACE: all instances of the second string in the first are replaced by the third string
2.REPLACE(): replace all occurrences of one character or substring
3.REPLACE spaces