From: Erland Sommarskog on 31 Jan 2010 17:45 Muhammad Bilal (MuhammadBilal(a)discussions.microsoft.com) writes: > Thankx for your reply. I am using the following function for a single > column with comma values. Problem is that i cannot understand how to use > it for more than one comma valued columns. As in my case I have 6 > columns. You have to get the values into variables since you are on SQL 2000. You cannot pass a table column to table-UDF in SQL 2000. -- Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx |