The Like Operator is used in Filters and Parameters for doing pattern matching. Combinations of literal characters and wildcard characters can be used to locate patterns. The two wildcard characters that are supported by most Data Access Drivers are the _ (underscore) wildcard; which means any single character, and the % (percent) wildcard; which means any zero or more characters. For example the pattern _a_b% would match any words that have an ‘a’ as the second character and a ‘b’ as the fourth character.
Additional symbols for pattern matching are supported by some Data Access Drivers. These may include:
Enjoyed this Sage Intelligence Tip?
Join over 3,000+ subscribers in receiving Sage Intelligence tips and tricks in your inbox twice a month and to get access to all our Sage Intelligence Tips and Tricks e-books.