|
This is a user-defined table function that takes one input parameter @list of the type ntext which should hold a comma-separated list of string values. The function returns a table with three columns:
listpos int IDENTITY(1, 1) NOT NULL, str varchar(4000), nstr nvarchar(2000)
listpos reflects the postion of the string in the list. str and nstr holds the same value (save any mutilation which may happen to Unicode chars that does fit into varchar). You use the column which matches the table you join with. |
|
|
|