Step 1 – Searching Various Fields

1. Find the Client Search page
2. We will search various fields in this page using PL/SQL operators

Step 2 – Text

1. LIKE
   
   1. Use '%' to match groups of characters, for example '%ill' will return "Mill", "Gill" and "Seagill"
   2. Use '_' to match single characters, for example '_ill' will return only "Mill" and "Gill"
2. EQUAL
   
   1. Will only return exact matches

Step 2 – Number

1. EQUAL
2. GREATER
3. LESS 

Step 3 – Date

1. BETWEEN