SQL REPLACE() function replaces all occurrences of a substring within a string, with a new substring. It performs string manipulations within queries or scripts and it returns nvarchar if one of the input arguments is nvarchar data type; otherwise, it returns varchar.
For more articles, kindly visit www.SQLServerLog.com