thanks for the alternate solution it works.

I had also worked around the problem with a similar solution. Our company does not let us use "sp_executesql" for security reasons.