1502033 - SQL Transform incorrectly converts single quoted values to double quoted values

Using the “{“(curly brackets) in SQL Transform to substitute variable value incorrectly converts values from single quotes to double quotes.

For example:
$GVTest = CA’,’BC’,’FL;

When using the above variable in a SQL select statement clause as follows:

Where State in ({$GVTest})

incorrectly returns ‘CA’’,’’BC’’,’’FL’

Data Services 12.2

single quotedouble quote , KBA , EIM-DS , Data Services , Bug Filed