# How to use SQL LIKE Wildcard in MSSQL Execute Step

**URL:** https://www.finalbuilder.com/forums/t/how-to-use-sql-like-wildcard-in-mssql-execute-step/1345
**Category:** Discussion
**Created:** [October 16, 2009, 7:16am UTC](https://www.finalbuilder.com/forums/t/how-to-use-sql-like-wildcard-in-mssql-execute-step/1345 "2009-10-16T07:16:31Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![deleted\_user](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/deleted_user/32/937_2.png) [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)
#### Post date: [October 16, 2009, 7:16am UTC](https://www.finalbuilder.com/forums/t/how-to-use-sql-like-wildcard-in-mssql-execute-step/1345/1 "2009-10-16T07:16:31Z")

</div>

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

SELECT&nbsp;\*&nbsp;FROM&nbsp;Table WHERE&nbsp;Col LIKE&nbsp;'%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&nbsp;save it and try to run, the step fails because there is no trailing %.

How do I&nbsp;run this query?

---

<div class="post-metadata">

### Author: ![deleted\_user](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/deleted_user/32/937_2.png) [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)
#### Post date: [October 16, 2009, 7:24am UTC](https://www.finalbuilder.com/forums/t/how-to-use-sql-like-wildcard-in-mssql-execute-step/1345/2 "2009-10-16T07:24:45Z")

</div>

Found the answer in the documentation:   
  
 To insert a percent sign, use %% - ie “%%Hello” will expand to “%Hello”.