[albert018]

I got another interesting question.

how to translate the following segment of code into parameter?

select * from employee where idno in ('A00001','B00001','C00001')

Is there any suggestion about it??

[Curtis Rutland]

That's a lot more complex, since they don't have a proper built in mechanism to handle that. Here's an article on how you can achieve the same results:

http://www.codeproje...tored-Procedure