Say I have a table that contains a column with values. Some of these values have wildcards embedded in them.
| SearchVal |
|---|
| AttachmentTest2 |
| SomethingElse |
| AttachmentTest% |
Given the string AttachmentTest2, I want a query that will return the first and third row, essentially returning any row that would return AttachmentTest2 if searched using the expression in the table.
I tried
Select * from MyTable Where 'AttachmentTest2' like SearchVal
but that didn’t give me all the results that would match, just AttachmentTest2.
Is this something that is possible to do with a query?