Split values in an variable in SQL Server 2005

Question

I have a varchar variable been defined like this.

declare @IDs varchar(50)
set  @IDs ='111,123,567,'

Now I need to extract the last value in the list always 567.

The values in @IDs can be like this also

set  @IDs ='56,'

In this case we need extract only the value 56.

How can we do it?

Something similar has already been asked: http://stackoverflow.com/questions/314824/t-sql-opposite-to-string-concatenation-how-to-split-string-into-multiple-reco — David Brabant, Feb 21 '12 at 06:44

score 1 · Accepted Answer · answered Feb 21 '12 at 06:12

1

i think you will find this user defined function to split the string helpful:

answered Feb 21 '12 at 06:12

Vikram

score 0 · Answer 2 · answered Feb 21 '12 at 12:29

It is very fast, you can call it like so:

SELECT *
FROM dbo.DelimitedSplit8K(@IDs,',')

This will return you a result set of all the values in the string.

2 Answers2