Parameter Problem

[Nagaraj]

Hi All,

I am using a simple Select statement and i am trying to parameterise the Where clause on one column which can be an integer or varchar or char.
i am getting the problem when i run the job.

example

select col1,col2 from T #p#

where p >> where col1= 'A'

Note col1 is varchar

i can use one more quote and suppress the quote but i will have to use two parameters like

select col1,col2 from T #p# #Q#

Q >> 'A'

[Nagaraj]

Thanks all .....got it by using escape character \

example

Q >> \'A\'