# Using percent

**URL:** https://www.finalbuilder.com/forums/t/using-percent/477
**Category:** Discussion
**Created:** [May 29, 2007, 8:33am UTC](https://www.finalbuilder.com/forums/t/using-percent/477 "2007-05-29T08:33:29Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![lancerasmussen](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/l/f6c823/32.png) [@lancerasmussen](https://www.finalbuilder.com/forums/u/lancerasmussen)
#### Post date: [May 29, 2007, 8:33am UTC](https://www.finalbuilder.com/forums/t/using-percent/477/1 "2007-05-29T08:33:29Z")

</div>

I'm doing a LIKE statement and need to use a %, but FB can't get past thinking its a variable.

How do I get around this?

---

<div class="post-metadata">

### Author: ![tate](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/t/e19b73/32.png) [@tate](https://www.finalbuilder.com/forums/u/tate)
#### Post date: [May 29, 2007, 8:35am UTC](https://www.finalbuilder.com/forums/t/using-percent/477/2 "2007-05-29T08:35:44Z")

</div>

you need to escape %'s with another %, eg. your query could be:  
Select \* from Company where companyname like ‘micro%%’  
  
.t8

---

<div class="post-metadata">

### Author: ![lancerasmussen](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/l/f6c823/32.png) [@lancerasmussen](https://www.finalbuilder.com/forums/u/lancerasmussen)
#### Post date: [May 31, 2007, 3:05am UTC](https://www.finalbuilder.com/forums/t/using-percent/477/3 "2007-05-31T03:05:18Z")

</div>

Hmm.&nbsp; I thought I did that...&nbsp; I'll try again.