Breaking News: Grepper is joining You.com. Read the official announcement!

String split in sql server

Add Answer

Rasel Ahmed answered on January 6, 2022 Popularity 10/10 Helpfulness 7/10

answer String split in sql server

related how to split string value in sql server

related split sql

related sql Split string function

String split in sql server

Comments(1)

SELECT [Value] FROM STRING_SPLIT('Lorem ipsum dolor sit amet.', ' ');

Popularity 10/10 Helpfulness 7/10 Language sql

Source: Grepper

Tags: sql sql-server

Link to this answer
Share Copy Link

Contributed on Jun 14 2022

Rasel Ahmed

0 Answers Avg Quality 2/10

Closely Related Answers

how to split string value in sql server

Comment

-1

SELECT value
FROM STRING_SPLIT('An example sentence.', ' ');

Popularity 10/10 Helpfulness 7/10 Language sql

Source: learnsql.com

Tags: sql

Link to this answer
Share Copy Link

Contributed on Nov 21 2022

PROSANTO BISWAS

0 Answers Avg Quality 2/10

split sql

Comment

-- Assume you have the CTE
WITH cte AS (
    SELECT STRING_AGG(Country, ', ') AS ConcatenatedCountries
    FROM Country_Medals
)
SELECT value AS Country
FROM cte
CROSS APPLY STRING_SPLIT(cte.ConcatenatedCountries, ', '); -- Use STRING_SPLIT with CROSS APPLY

-- Split into words
SELECT 
    CASE 
        WHEN category LIKE '%: %' THEN SPLIT_PART(category, ': ', 1)
        WHEN category LIKE '% - %' THEN SPLIT_PART(category, ' - ', 1)
        ELSE SPLIT_PART(category, ' | ', 1)
        END AS major_category, -- alias the result
sum(businesses) -- also select number of businesses
FROM naics
GROUP BY major_category;

Popularity 9/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Feb 02 2024

Innocent Iguana

0 Answers Avg Quality 2/10

sql Split string function

Comment

CREATE FUNCTION [dbo].[Func_SplitString] 
( @Values VARCHAR(MAX)
, @splitStr VARCHAR(50)
)

RETURNS @Result_Table TABLE
       (
	     [value] nvarchar(MAX) NULL
       )
BEGIN
    DECLARE @TempStr nvarchar(MAX)
    WHILE (CHARINDEX(@splitStr,@Values)>0)
    BEGIN
        SET @TempStr=SUBSTRING(@Values,1,CHARINDEX(@splitStr,@Values)-1)
        INSERT INTO @Result_Table (value) VALUES (ltrim(rtrim(isnull(@TempStr, ''))))
        SET @Values = REPLACE(@Values,@TempStr+@splitStr,'')
    END/*End While*/
	
    IF(LEN(RTRIM(LTRIM(@Values)))>0 AND CHARINDEX(@splitStr,RTRIM(LTRIM(@Values)))=0) 
    BEGIN
        SET @TempStr=@Values 
        INSERT INTO @Result_Table (value) VALUES (ltrim(rtrim(isnull(@TempStr, ''))))
    End /*End IF*/
   RETURN 
END

Popularity 10/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Jan 06 2022

BlackSwan

0 Answers Avg Quality 2/10

String split in sql server

Contents

More Related Answers

String split in sql server

Closely Related Answers

how to split string value in sql server

split sql

sql Split string function

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.