SQL function Learning (16): STUFF () function

16.STUFF () function

The STUFF () function deletes characters of a specified length and can insert another set of characters at the point at which it was established.

16.1 STUFF () function syntax

Select Stuff (column name, start position, length, substitution string)

16.1STUFF () Function instance

Requirement: Remove three characters after the seventh character of the Chinese name.

Select Chinese name, Stuff (Chinese name, 7,3, ') as new
From GDBZ

Execution Result:

Requirement: Remove the three characters after the seventh character of the Chinese name, and replace the deleted characters with "I Love You".

The statements are as follows:

Select Chinese name, Stuff (Chinese name, 7, 3, ' I Love You ') as new
From GDBZ

Execution Result:

Note: When the start position and the length are negative, "null" is returned.

Original reprint Office http://blog.sina.com.cn/s/blog_5f0493880100ttpp.html

SQL function Learning (16): STUFF () function