Wildcard in SQL query with input param

[ague]

I need to make a SQL query in Thingworx. The query should read (if I were creating it directly):

SELECT * FROM MyDB.MyTable where Name like '%Name_Input%'

Another PTC forum post had recommended this as a possible solution:

SELECT * FROM MyDB.MyTable where Name like '%' || [[Name_Input]] || '%'

But this query (above) does not work. The post was from the year 2014 and I'm currently using 8.4.1, so I'm guessing that's the issue.....

Solutions anyone?

[posipova]

This could have been changed due to the changed security policies. I will verify and get back to you/this thread with an update.

[posipova]

This was part of security updates, works to spec.

[ague]

So, when you say, 'works to spec', are you saying that this SQL query should in fact work? 

[posipova]

Wildcard should not work, sql queries should work.

[ague]

So, how can I execute a SQL query that needs to take in a variable? What's the work-around for this?

[posipova]

Does this help? https://www.ptc.com/en/support/article/CS261346

[ague]

It tells me how to use a variable from a user (fine, I know how to do that), but it doesn't mention being able to user wildcards WITH the variable. 

I know I can use wildcards WITHOUT a variable.

[posipova]

I don't think we support wildcard without a variable/security patches.

[ague]

Please elaborate on what 'variable patches' are. 

[posipova]

I apologize for wording that poorly. "/" Should be read as "(security patches)".

[ague]

What security patches are required then? What updates do I need? 

[posipova]

It's already part of the newer build that's why the suggestion from older (2014) thread did not work. I'll place an improvement request on your behalf.

[JT_OU812]

I had the same issue, here's what I found to work, this works in 9.4.1:
SELECT * FROM MyDB.MyTable where field_values LIKE '%'+[[source]]+'%'