Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Enterprise
Expertise: Intermediate
Oct 8, 2001

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 locations
DECLARE @mystring varchar(255), @myword varchar(50)
DECLARE @i int,@j int
SELECT @mystring = 'vb,asp,sqlserver,html'
SELECT @i = 0,@j = 0
IF SUBSTRING (@mystring, LEN (@mystring), 1) <> ','
BEGIN
   SELECT @mystring = @mystring + ','
END
SELECT @i = CHARINDEX (',', @mystring, @i + 1)
WHILE @i > 0
BEGIN
   SELECT @myword = SUBSTRING (@mystring, @j+1, 
(@i - @j) -1)
   SELECT @myword
   SELECT @j = @i
   SELECT @i = CHARINDEX (',' , @mystring, @i + 1)
END
Harinatha Reddy
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date