What would be easier using stored procedures or preparing with dynamic SQL?

Jon

what would be easier, using a stored procedure or dynamic SQL?

I need a little clarification.

Thanks Ray.

Do I need to put that in a function? When exactly do I put your statement at?

Thanks for the help.

Jon

AJ-

Im not quite sure what you are getting at? I am not an expert at RS. When you use a like statement dont you have to specify a pattern.

For example:

SELECT...