hi,

The @rid is taking the multi values by comma seperated....

ex: 12,45,24,3,78 ..

So the datatype int only takes single value of int only...it doesnot allow the above value...

For that change the @rid datatype to NVACHAR(<length/MAX>) or VARCHAR(<length/MAX>) in Ur SP.

Use the select stmt as...

Select rid,name,col2,col3 from tblename where rid in (Select fieldvalue from getorder(@rid))

getOrder table function code is availabale in my posts for Sort order....

look into that u should get clear picture that how to solve this issue...

For multi value selection u should use varchar/nvarchar datatype in the backend..

:-):-)

Sasidhar Chowdary