[MSSQL] STUFF

STUFF

문자열에 글자를 치환하고 싶은 경우 사용한다.

STUFF (string_expression, start, length, replacement_expression)

• string_expression : 원본 문자열
• start : 변경될 문자의 시작위치
• length : 변경될 길이 수
• replacement_expression : 새로운 문자열

# 1

SELECT STUFF('Hello, world!', 7, 5, 'there')

Hello, there!

# 2

SELECT STUFF('1234567890', 6, 0, '-')

12345-67890

# 3 

SELECT Name,
       STUFF(Name, CHARINDEX(' ', Name), LEN(Name), '') AS FirstName
FROM Employees

Name	FirstName
John Smith	John

 

---

There might be incorrect information or outdated content.