User defined function value and WHERE...IN clause

I cannot get a scalar return value from a user defined function to work in a WHERE...IN clause in SQL Server 2000.  I am testing in SQL Query Analyzer

getPQStatusFromFacilID(190) is a user defined function that works outside the select statement
lu_PQStatus is a table with pqStatusID as the primary key

If I run this Query
declare @PQStatus varchar(500)
set @PQStatus = dbo.getPQStatusFromFaciID(190)
print @PQStatus
I get this
'ASR','ASRE','ASRN','ASRS','ASRW','ACS','ACW','CD','CDE','CDN','CDS','CDW','CI','CIE','CIN','CIS','CIW','DC','DCE','DCN','DCS','DCW','FD','FDE','FDN','FDS','FDW','FF','FFE','FFN','FFS','FFW','GC','GCE','GCN','GCS','GCW','LC','LCE','LCN','LCS','LCW','PAR','PARE','PARN','PARS','PARW'

If I manually put the output from the above into this query
select * from lu_PQStatus
where pqStatusID IN ('ASR','ASRE','ASRN','ASRS','ASRW','ACS','ACW','CD','CDE','CDN','CDS','CDW','CI','CIE','CIN','CIS','CIW','DC','DCE','DCN','DCS','DCW','FD','FDE','FDN','FDS','FDW','FF','FFE','FFN','FFS','FFW','GC','GCE','GCN','GCS','GCW','LC','LCE','LCN','LCS','LCW','PAR','PARE','PARN','PARS','PARW')
I get the output that I want

However, if I substitute the return value from the function call
declare @PQStatus varchar(500)
set @PQStatus = dbo.getPQStatusFromFaciID(190)
select * from lu_PQStatus
where pqStatusID IN (@PQStatus)
I get no records

Is the value from the function call getting parsed in some way that the select statement cannot recognize it?  Any help would be greatly appreciated.


Start Free Trial