Query issue

[nani0907]

Hi,

I ahve a sql query with IN statement.when i use the hard coded values like('X','Y','Z') .it works.when i use parameter ,the job doesnot return result.Please help me

[chulett]

Quotes are stripped from parameters, you'll need to escape them in order to preserve them. An exact search for "escape" should turn up many conversations on this topic here, btw.

[arun_im4u]

Check this post..

viewtopic.php?t=128561&highlight=