How to use REPLACE function in Sql Server

Today, I will talk to you about how to use the REPLACE function in Sql Server. Many people may not know much about it. In order to let everyone know more, Xiaobian summarizes the following contents for everyone. I hope everyone can gain something according to this article.

REPLACE

Replace all occurrences of the second given string expression in the first string expression with the third expression.

syntax

REPLACE ( ''string_replace1'' , ''string_replace2'' , ''string_replace3'' )

parameters

''string_replace1''

String expression to search for. String_replace1 can be character data or binary data.

''string_replace2''

String expression to be found. String_replace2 can be character data or binary data.

''string_replace3''

String expression for substitution. String_replace3 can be character data or binary data.

return type

Returns character data if string_replace (1, 2, or 3) is one of the supported character data types. Binary data is returned if string_replace (1, 2, or 3) is one of the supported binary data types.

example

The following example replaces the string cde in abcdefghi with xxx.

SELECT REPLACE(''abcdefghicde'',''cde'',''xxx'')GO

Here is the result set:

------------abxxxfghixxx(1 row(s) affected)

After reading the above, do you have any further understanding of how to use the REPLACE function in Sql Server? If you still want to know more knowledge or related content, please pay attention to the industry information channel, thank you for your support.