# Suppress variable replacement

**URL:** https://www.finalbuilder.com/forums/t/suppress-variable-replacement/572
**Category:** Discussion
**Created:** [August 24, 2007, 8:23am UTC](https://www.finalbuilder.com/forums/t/suppress-variable-replacement/572 "2007-08-24T08:23:06Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![chanmy8](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/c/f475e1/32.png) [@chanmy8](https://www.finalbuilder.com/forums/u/chanmy8)
#### Post date: [August 24, 2007, 8:23am UTC](https://www.finalbuilder.com/forums/t/suppress-variable-replacement/572/1 "2007-08-24T08:23:06Z")

</div>

Hi,

I have sql script that contains '%something%' with LIKE clause. I found that, FB will try to evaluate it in MSSQL Execute SQL action. However, since it is not actually a variable, the'%something%' is replace with empty string.

Anyway to suppress variable replace in this case?

Thank you

---

<div class="post-metadata">

### Author: ![Vincent](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/vincent/32/938_2.png) [@Vincent](https://www.finalbuilder.com/forums/u/Vincent)
#### Post date: [August 24, 2007, 11:05am UTC](https://www.finalbuilder.com/forums/t/suppress-variable-replacement/572/2 "2007-08-24T11:05:22Z")

</div>

Yes,   
  
 you need to escape the % characters with another %, eg : ‘%%something%%’

---

<div class="post-metadata">

### Author: ![chanmy8](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/c/f475e1/32.png) [@chanmy8](https://www.finalbuilder.com/forums/u/chanmy8)
#### Post date: [August 24, 2007, 12:01pm UTC](https://www.finalbuilder.com/forums/t/suppress-variable-replacement/572/3 "2007-08-24T12:01:19Z")

</div>

Hi,

I tried to change my sql script as below, but FB still replace it with ''.

ame like '%%nobalshare%%'

---

<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: [August 27, 2007, 5:26am UTC](https://www.finalbuilder.com/forums/t/suppress-variable-replacement/572/4 "2007-08-27T05:26:47Z")

</div>

Hi Chan,   
  
 The escaping is working fine for us - can you please send us an example project that shows the behaviour you’re seeing? Please send to support at finalbuilder dot com   
  
 thanks.

---

<div class="post-metadata">

### Author: ![chanmy8](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/c/f475e1/32.png) [@chanmy8](https://www.finalbuilder.com/forums/u/chanmy8)
#### Post date: [August 30, 2007, 4:59am UTC](https://www.finalbuilder.com/forums/t/suppress-variable-replacement/572/5 "2007-08-30T04:59:47Z")

</div>

Hi,

I have sent my FB project and sample script to support@finalbuilder.com two days ago. Hope you have recieve it and hear your reply soon.

&nbsp;

Thank you

---

<div class="post-metadata">

### Author: ![angus](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/a/b3f665/32.png) [@angus](https://www.finalbuilder.com/forums/u/angus)
#### Post date: [August 30, 2007, 9:45am UTC](https://www.finalbuilder.com/forums/t/suppress-variable-replacement/572/6 "2007-08-30T09:45:06Z")

</div>

Hi Chan,   
  
 Thanks for the heads-up. We have received the file, and will get back to you with an answer soon.   
  
 Regards,   
  
 Angus

---

<div class="post-metadata">

### Author: ![angus](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/a/b3f665/32.png) [@angus](https://www.finalbuilder.com/forums/u/angus)
#### Post date: [September 3, 2007, 2:53am UTC](https://www.finalbuilder.com/forums/t/suppress-variable-replacement/572/7 "2007-09-03T02:53:58Z")

</div>

Hi Chan,   
  
 You have a reply via email.   
  
 Regards,   
  
 Angus