String Literals in the script

[#1]

Hi Folks,

I need create the string like below and used this sting in my SQL query.

Let vValues = 'India','Usa','Aus';

My SQL: Select * from Customer where Country in ($(vValues ))

How can i do that in the script.

Thanks & Regards,

Siri

[CELAMBARASAN]

Hi,    

     Check with it

     Let vValues = chr(39)&'India'&chr(39)&','&chr(39)&'Usa'&chr(39)&','&chr(39)&'Aus'&chr(39);

Celambarasan

[jonathandienst]

Siri

You can just di this:

Set vValues = 'India','Usa','Aus';

Regards

Jonathan