SQL STRING_SPLIT Function

The SQL STRING_SPLIT function is used to split the string expressions using a specified separator, and its syntax is STRING_SPLIT (String_Expression, Separator) The list of arguments available for the method is: SQL String_Split Function Example The following String query will split the declared string using empty spaces in between the words. DECLARE @Expression varchar(50) SET … Read more