Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Append Value to Delimited List

By Chad Casady, 2011/03/04

This script returns "@ValueList" with "@Item" appended to it.

 

Example Usage:

declare @mylist nvarchar(100)
set @mylist = 'A,B, C, D , 1, 2,345, EFG, H'
select dbo.fn_ListAppend(@mylist, 8, ',')

Returns "A,B, C, D , 1, 2,345, EFG, H,8"

 

This script is part of a series of list-scripts:

"fn_ListAppend"

"fn_ListCount"

"fn_ListGetAt"

"fn_ListPrepend"

Total article views: 6015 | Views in the last 30 days: 5
 
Related Articles
FORUM
FORUM

Script

Need Automated Script

FORUM

drop script

drop script

FORUM

script errors

script errors

Tags
t-sql    
udf    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones