DSXchange

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

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.

Check this post..

viewtopic.php?t=128561&highlight=