Sql Server REPLACE函数

最新推荐文章于 2024-07-15 11:27:42 发布

衣舞晨风

最新推荐文章于 2024-07-15 11:27:42 发布

阅读量2.3k

点赞数 1

本文链接：https://blog.csdn.net/jiankunking/article/details/25869263

版权

Sql Server 专栏收录该内容

66 篇文章 2 订阅

订阅专栏

Replaces all occurrences of a specified string value with another string value.
语法：
REPLACE ( string_expression , string_pattern , string_replacement )
参数：
string_expression
Is the string expression to be searched. string_expression can be of a character or binary data type.
string_pattern
Is the substring to be found. string_pattern can be of a character or binary data type. string_pattern cannot be an empty string (''), and must not exceed the maximum number of bytes that fits on a page.
string_replacement
Is the replacement string. string_replacement can be of a character or binary data type.
返回
Returns nvarchar if one of the input arguments is of the nvarchar data type; otherwise, REPLACE returns varchar.
Returns NULL if any one of the arguments is NULL.
If string_expression is not of type varchar(max) or nvarchar(max), REPLACE truncates the return value at 8,000 bytes. To return values greater than 8,000 bytes, string_expression must be explicitly cast to a large-value data type.
即用第三个表达式替换第一个字符串表达式中出现的所有第二个给定字符串表达式。

例子：

SELECT REPLACE('AAAAAXXXAAA','X','A');

结果：