devxlogo

Dealing with Delimited Strings in T-SQL

Dealing with Delimited Strings in T-SQL

This is a simple way to find out the word count in a comma delimited string:

 declare @mystring varchar(200)set @mystring="vb,asp,sqlserver,html"select (len(@mystring)-len(replace(@mystring,',',''))+1)

The following code will parse the delimited string:

 --variable i is for current and j for previous locationsDECLARE @mystring varchar(255), @myword varchar(50)DECLARE @i int,@j intSELECT @mystring = 'vb,asp,sqlserver,html'SELECT @i = 0,@j = 0IF SUBSTRING (@mystring, LEN (@mystring), 1) <> ','BEGIN   SELECT @mystring = @mystring + ','ENDSELECT @i = CHARINDEX (',', @mystring, @i + 1)WHILE @i > 0BEGIN   SELECT @myword = SUBSTRING (@mystring, @j+1, (@i - @j) -1)   SELECT @myword   SELECT @j = @i   SELECT @i = CHARINDEX (',' , @mystring, @i + 1)END
See also  How AI Art Generators Can Save Time and Money for Startups
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist