# Poucentage Character

**URL:** https://www.finalbuilder.com/forums/t/poucentage-character/7101
**Category:** Discussion
**Created:** [August 18, 2021, 8:23am UTC](https://www.finalbuilder.com/forums/t/poucentage-character/7101 "2021-08-18T08:23:26Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![exploit-aq](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/e/59ef9b/32.png) [@exploit-aq](https://www.finalbuilder.com/forums/u/exploit-aq)
#### Post date: [August 18, 2021, 8:23am UTC](https://www.finalbuilder.com/forums/t/poucentage-character/7101/1 "2021-08-18T08:23:26Z")

</div>

Hello Everybody,

I use automise from many years to manage all IT flow and i’m very satisfy. Thank for your job.

I post here because i have a problem with pourcentage character. Automise use it for variable so it’s complicated to use some SQL request (ADO execute SQL for example) like :  
select \* from XXX where YYY like ‘%MANAGE%’

Automise show me an error message :

Error expanding Content : [Expression Error]: Variable\Object " " does not exist!

Other case : I export some data with ADO Execute SQL and when i have a pourcentage character in data, i can’t use it with variable.

Do you have any idea to workaround the problem ?

Have a good day,

Jack

---

<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 18, 2021, 8:47am UTC](https://www.finalbuilder.com/forums/t/poucentage-character/7101/2 "2021-08-18T08:47:35Z")

</div>

Hi Jack

You need to escape the % symbols

e.g

```sql
select * from XXX where YYY like ‘%%MANAGE%%’

```

See the help :  
[https://wiki.finalbuilder.com/display/AT5/Escaping+Variable+References](https://wiki.finalbuilder.com/display/AT5/Escaping+Variable+References)

---

<div class="post-metadata">

### Author: ![exploit-aq](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/e/59ef9b/32.png) [@exploit-aq](https://www.finalbuilder.com/forums/u/exploit-aq)
#### Post date: [August 18, 2021, 9:23am UTC](https://www.finalbuilder.com/forums/t/poucentage-character/7101/3 "2021-08-18T09:23:36Z")

</div>

Thank for the wiki link. I didn’t see it.  
Have a good day.
