>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 udfParseCommaListToTable(@sTransTypeCodes, ',') AS TranCodes
>
>SELECT *
> 	FROM Transactions
>	WHERE sTrans_Type_CD IN
>		(SELECT DataItems FROM from udfParseCommaListToTable(@sTransTypeCodes, ','))
>

See changes inline.

Or you can also try:

select Tr.* from Transactions Tr 
INNER JOIN (select * FROM udfParseCommaListToTable(@sTransTypeCodes, ',')) Codes 
on Tr.sTrans_Type = Codes.DataItems