Walk the string

0

Please login or register to vote for this query.

(click on this box to dismiss)

Islam Meta

Q&A about the site for Muslims, experts in Islam, and those interested in learning more about Islam

declare @S varchar(20)
set @S = '1, 2,3 , 4 ,5'

Set @s = @s + ','

while len(@S) > 0
begin
print @s + '   ' + '"' + rtrim(ltrim(left(@S, charindex(',', @S)-1))) + '"'
  -- set @S = stuff(@S, 1, charindex(',', @S), '')
  set @S = substring(@S, charindex(',', @S)+1, len(@s))
end

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results