T-SQL code to concatenate all the values of a column into one row

/****************************************/
Purpose: To concatenate the values of a column in all rows into one row.
Written by: Allan Mitchel    http://www.allisonmitchell.com
Tested on: SQL Server 7.0 and SQL Server 2000
Date modified: March-22-2001 6:30 PM
Email: vyaskn@hotmail.com
NOTE: A limitation to be aware of is that varchar can go upto a max size of
8000 characters. If your data occupies more space, the output will be
truncated.
****************************/

USE pubs
GO
DECLARE @title_ids varchar(150), @delimiter char
SET @delimiter = ','
SELECT @title_ids = COALESCE(@title_ids + @delimiter, '') + title_id FROM titles
SELECT @title_ids AS [List of Title IDs]