MSSQLString FunctionsSTRING_SPLIT
STRING_AGG

STRING_SPLITString Functions

QUOTENAME

Splits a string by a separator and returns a row set.

Syntax

STRING_SPLIT(str, sep)

Example

Enter values below to update the example in real time.

value
tag
-- 콤마로 구분된 태그 분리
SELECT value AS tag
FROM STRING_SPLIT('서울,부산,제주', ',');