I am trying to pass an input parameter to a SQL statement using the like command. I cannot figure out how to write the statement using like.
Select * from xxx where column like '%abc%' is what works.
If I pass an input value, how do I structure the statement:
Select * from xxx where column like '%[[parameter]]%' does not work.
My guess is Sabarish already spoke with you, but to concatenate two wildcards to the beginning and end of your input, you can use the '||' operator. For example,
SELECT * from xx WHERE column LIKE '%' || [[input]] || '%'
Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum!