How to use SQL LIKE Wildcard in MSSQL Execute Step

FinalBuilder Discussion
1

I want to do a Text Query in a MSSQL Execute Step like

SELECT * FROM Table WHERE Col LIKE '%word'

However, the GUI expands out and says there is no matching variable. It thinks I'm trying to use a FinalBuilder variable. If I save it and try to run, the step fails because there is no trailing %.

How do I run this query?

2

Found the answer in the documentation:

To insert a percent sign, use %% - ie “%%Hello” will expand to “%Hello”.