In Query Database smart service, i am trying to use INSTR function. I want

In Query Database smart service, i am trying to use INSTR function.
I want to retrive column value based on anothr column used in a IN clause in normal sql.
My query goes like:

Select b.firstName, b.lastName from TableDetails B where INSTR(ac!cityList, concat("'",b.city,"'"))
But while validating it gives me error sayin incorrect syntax near keyword FROM.
Can someone let me know how to use INSTR function.

In the above query my cityList is constructedt hru a script task like:
concat("'",joinarray(cityArray,","),"'")

I tried it with the below page reference.

forum.appian.com/.../apps

I am using MS SQL database.

Thanks in advance....

OriginalPostID-62076

OriginalPostID-62076