>>I wrote another UDF to convert a comma delimited list of string values to a table. When I call it, I get "Invalid object name 'TranCodes'". The error is occuring on the last query:
>>
>>
>>

>>DECLARE @sTransTypeCodes varchar(50)
>>SET @sTransTypeCodes = 'PR,PD'
>>
>>
>>
>>SELECT *
>> 	FROM Transactions
>>	WHERE sTrans_Type_CD IN
>>		(SELECT DataItems FROM TranCodes)
>>

>
>I prefer JOIN syntax :
>

>SELECT *
>       FROM Transactions
>INNER JOIN (SELECT DataItems FROM udfParseCommaListToTable(@sTransTypeCodes, ',') AS TranCodes
>      ON Transactions.sTrans_Type_CD = TranCodes.DataItems
>

Me too, but we're both too late :) No way competing with Sergey.