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"
   3. Type a series of words seperated by only commas and no spaces to see them all, for example "Max,Alex" or "_ax,%ex"
2. EQUAL
   
   1. Will only return exact matches

Step 3 – Number

1. EQUAL
2. GREATER
3. LESS 

Step 4 – Date

1. BETWEEN