Would like to know, if this is the correct method of using the LIKE in a Condition?
Solved
Event Action Details Conditions
Best answer by Charana Udugama
Hi
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
This topic has been closed for comments
+12Hi
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.