# Pass Wildcard Parameters on Named Queries

**URL:** <https://forum.inductiveautomation.com/t/pass-wildcard-parameters-on-named-queries/34594>\
**Category:** Ignition\
**Tags:** namedqueries, ignition79, ignition80, database, scripting\
**Created:** [May 8, 2020, 11:09pm UTC](https://forum.inductiveautomation.com/t/pass-wildcard-parameters-on-named-queries/34594 "2020-05-08T23:09:54Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [May 10, 2020, 11:00pm UTC](https://forum.inductiveautomation.com/t/pass-wildcard-parameters-on-named-queries/34594/6 "2020-05-10T23:00:27Z")

</div>

LIKE doesn’t work for integer columns, only for string columns. I would make another named query. IA isn’t charging you for extra ones, after all. 😄

---

_[View the full topic](https://forum.inductiveautomation.com/t/pass-wildcard-parameters-on-named-queries/34594)._