SQL SERVER – UDF – Function to Convert List to Table | Journey to SQL Authority with Pinal Dave

Following Users Defined Functions will convert list to table. It also supports user defined delimiter. Following UDF is written for SQL SERVER 2005. It will also work well with very big TEXT field. If you want to use this on SQL SERVER 2000 replace VARCHAR(MAX) with VARCHAR(8000) or any other varchar limit. It will work… Continue Reading...

Source: SQL SERVER – UDF – Function to Convert List to Table | Journey to SQL Authority with Pinal Dave