4.9.7 Using Wildcards to Make a Query

You need not always specify the criteria. You can use Wildcards such as * or%, to see a particular set of criteria. For instance, in the LC module, you have defined both loan products. All LC products have a Product Code that starts with LD (LD01, LD02 etc.), and all deposit products have a Product Code that begins with DP (DP01, DP (DP01, DP02, etc.).

Now suppose you want to see only the LC products and you know that they all begin with LD, instead of specifying each from the list of Values, you can give the Operator as Like and in the Value field key in LD%.

Once you click Accept and make a query, the ‘Contract Summary’ screen displays all the LC products.