cancel
Showing results for 
Search instead for 
Did you mean: 

Wild Card

Former Member
0 Kudos

What is the wild card for IS?  * or % or something else?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

If you are using patterns or regular expressions then the period is the wildcard for any character and * means 0 or more occurances.  The expression (.*[0-9].*) would search for a number anywhere in the string.  There are also some other operators which are good to know such as + 1 or more rather than 0 or more.  The back of the IS manual has a full section on regular expressions and pattern matching.


I typically try to avoid the LIKE operator in expressions (rules, filters, etc.) and use it only in creating views.  If you are using LIKE then % is the wildcard as in SQL.  Concatenation uses || rather than + though so don't get yourself in trouble by trying to use a command LIKE '%' + $field + '%';

Former Member
0 Kudos

How to check two fields using like operator?

Example:-  Field 1     Field 2

                    A               AB

If Field 2 Contains the value in A then its Pass, else its fail

I tried using Field 1 LIKE % || Field 2 || %

But its not working

mageshwaran_subramanian
Active Contributor
0 Kudos

It is %.

example $parameter0 like '%test%';