Hi @dwils,

LIKE condition is used match patterns. This is almost same as what you use in Search in IFSAPPs.

For an example we need names starting with the letter ‘R’. We can put the value as ‘R%’. If we need something that ends with the letters ‘er’. We can put the value as ‘%er’. 

Here is a document on the usage of LIKE Oracle / PLSQL: LIKE Condition (techonthenet.com)

Hope this helps.

Regards,
Charana

yes thank you, Realized that after I saw your reply.

I overthought this one. 

I need an IN (), but it isn’t available.

I was looking for a way in the condition to say 900 or 500.

I can just try this.