Example 1:

Let us consider Record A with Record Number ‘ABC-R/2017/0001’ and Record B with ‘Record Number R0001’.

For a query, Record Number Contains R

Fig1.pngImage Added

It is going to find the exact match ‘R’ (as a separate letter) and returns just the Record A with Record Number ‘ABC-R/2017/0001’.

Example 2:

Let us consider Record A with Record Number ‘ABC-R/2017/0001’ and Record B with ‘Record Number R0001’.

For a query, Record Number Contains R*(‘*’ is a wildcard operator that indicates zero or more characters)

Fig2.pngImage Added

It is going to return both the records, Record A with Record Number ‘ABC-R/2017/0001’ and Record B with ‘Record Number R0001’.

Example 3

Suffix matching is not supported.

Let us consider Record A with Record Number R0000021, using Record Number Contains *21 is not supported.

The query to find this record would be Record Number Contains 21*, which would search for zero or more characters after 21 in each word and give the right result.