766209_en-US

liliconcom

how to apply variable to custom SQL

in custom SQL, this works. 

.....left join  c
on d.SCU = c.CU
where d.DE in (' 216532','216534')

in script, I define a variable: inString = ' 216532','216534'

then I like to run custom SQL:

.....left join  c
on d.SCU = c.CU
where d.DE in (' inString')

but i doesn't work. how do I use my variable in custom SQL correctly?

Data AccessRe: how to apply variable to custom SQL

You can use Eval Insert() 

inString = "'216532','216534'";

sql_template = "\[
	.....left join  c
on d.SCU = c.CU
where d.DE in (^inString^)
]\";

sql_str = Eval Insert(sql_template);