IN and Function

[PaulBarbeau]

I am trying to write a function where i pass in a list in of values like '1,2,3' and i want to return some information on the matching records. Normal i would build the sql string and then run it via exec(@sql) however exec does not work in a function. Anyone know how i can do this?

Paul

 

[checkai]

can you call a SP from the function and send it the list then have the function return those results?

dlc

 

[PaulBarbeau]

can not call a SP from a function unless it is a extended sp.

 

[SQLSister]

just use the SQL without making it a string and running exec.