Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to use REPLACE function in Sql Server

2025-01-18 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)05/31 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report