how split function work in sql [modified]

[findtango]

hi plzz tell me, if any one use split function in sql server 2000 i want to split one column data and then get coresponding values from another table like:- table_1 year code 2001 1,2,6 2002 2,5,6 table_2 code name 1 one 2 two 5 five 6 six i want to split code on(,)but this query is not working. "select name from table_2 where code=(split(select code from table_1 where year='2001'))" plzz help me thanks in advance john -- modified at 11:16 Wednesday 7th March, 2007

[Mark J Miller]

SQL Server doesn't have a SPLIT function, you have to write it yourself. Check out my article on using table-valued functions to create tables from string data. http://www.codeproject.com/cs/database/TableValuedFnsAsArrays.asp[^]