>>DECLARE @sTransTypeCodes varchar(50) >>SET @sTransTypeCodes = 'PR,PD' >> >> >> >>SELECT * >> FROM Transactions >> WHERE sTrans_Type_CD IN >> (SELECT DataItems FROM TranCodes) >>>
>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.