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: stackoverflow.com/questions/314824/… — David Brabant
– David Brabant, Commented Feb 21, 2012 at 6:44

Vikram · Accepted Answer · 2012-02-21 06:12:16Z

1

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

answered Feb 21, 2012 at 6:12

Vikram

8,32335 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vince Pergolizzi · Accepted Answer · 2012-02-21 12:29:30Z

0

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.

answered Feb 21, 2012 at 12:29

Vince Pergolizzi

6,6223 gold badges22 silver badges16 bronze badges