concatenating strings, commas and apostrophe into a string variable

[avigdova]

Hi,

I am trying to concatenate these strings into a variable :  xxx and yyy and use it later in WHERE clause.

The variable value should look like this:   'xxx', 'yyy'

while typing this chr(39)&'xxx'&chr(39)&', '&chr(39)&'yyy'&chr(39)

I am getting that:  "'xxx', 'yyy'"

how to elimanete the two " in the start and end of the variable?

[Mathumitha]

Hi @avigdova ,

You need to create 2 variables to handle this. 

vFirst=='#xxx#'&','&'#yyy#'

vSecond=Replace('$(vTest)','#',chr(39))

In the second variable, you'll get your expected output.

[Mathumitha · Accepted solution]

vFirst='#xxx#'&','&'#yyy#'

vSecond=Replace('$(vFirst)','#',chr(39))