# LIKE wildcards in Named Query

**URL:** <https://forum.inductiveautomation.com/t/like-wildcards-in-named-query/21169>\
**Category:** Ignition\
**Created:** [November 30, 2018, 9:04pm UTC](https://forum.inductiveautomation.com/t/like-wildcards-in-named-query/21169 "2018-11-30T21:04:13Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![bellm](https://avatars.discourse-cdn.com/v4/letter/b/b5e925/32.png) [@bellm](https://forum.inductiveautomation.com/u/bellm)\
**Post date:** [November 30, 2018, 9:04pm UTC](https://forum.inductiveautomation.com/t/like-wildcards-in-named-query/21169/1 "2018-11-30T21:04:13Z")

</div>

Quick question, is it possible to use a LIKE wildcard in a named query? If so how do you do it?

---

<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:** [November 30, 2018, 9:07pm UTC](https://forum.inductiveautomation.com/t/like-wildcards-in-named-query/21169/2 "2018-11-30T21:07:25Z")

</div>

I would pass the entire pattern of the LIKE as a parameter.

---

<div class="post-metadata">

**Author:** ![bellm](https://avatars.discourse-cdn.com/v4/letter/b/b5e925/32.png) [@bellm](https://forum.inductiveautomation.com/u/bellm)\
**Post date:** [November 30, 2018, 9:17pm UTC](https://forum.inductiveautomation.com/t/like-wildcards-in-named-query/21169/3 "2018-11-30T21:17:37Z")

</div>

Thats what I was afraid of, I have made a called template that has a StringInput property that is used in several places in my project. For my name query I am just handing it the StringInput value. Any suggestions of how to deal with that?

---

<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:** [November 30, 2018, 9:19pm UTC](https://forum.inductiveautomation.com/t/like-wildcards-in-named-query/21169/4 "2018-11-30T21:19:44Z")

</div>

Use your DB’s concat function to construct the complete pattern from the static part and your string parameter.

---

<div class="post-metadata">

**Author:** ![bellm](https://avatars.discourse-cdn.com/v4/letter/b/b5e925/32.png) [@bellm](https://forum.inductiveautomation.com/u/bellm)\
**Post date:** [November 30, 2018, 9:49pm UTC](https://forum.inductiveautomation.com/t/like-wildcards-in-named-query/21169/5 "2018-11-30T21:49:40Z")

</div>

Ah, thank you very much.

---

<div class="post-metadata">

**Author:** ![bellm](https://avatars.discourse-cdn.com/v4/letter/b/b5e925/32.png) [@bellm](https://forum.inductiveautomation.com/u/bellm)\
**Post date:** [November 30, 2018, 10:33pm UTC](https://forum.inductiveautomation.com/t/like-wildcards-in-named-query/21169/6 "2018-11-30T22:33:34Z")

</div>

Ok, so I got the concat to function like I wanted but I am having an issue with the filtering. Here is my code:

```auto
SELECT 
	HangerNumber,
	Room,
  	PartNumber,
  	PartDescription,
  	WorkOrder,
  	Customer, 
  	RecipeNumber,
  	CoatNumber,
  	RobotProgram,
  	EventDescription,
  	Temperature,
  	Humidity,
  	Weight,
  	TimeStamp,
  	Username
FROM 
	event_history
WHERE
	((TimeStamp >= :StartTime) AND (TimeStamp <= :EndTime)) AND
	((PartNumber LIKE concat(:PartNumber, '%')) OR
 (0 = :PartNumber)) AND
	((WorkOrder LIKE concat(:WorkOrder, '%')) OR (0 = :WorkOrder)) AND
	((PartDescription = concat('"':PartDescription, '%"')) OR (0 = :PartDescription)) AND
	((Customer LIKE concat(:Customer, '%')) OR (0 = :Customer))

```

The filters work when the data only includes numbers but wont filter if that are letters in any of the cells. Have any idea what I am doing wrong?