The LIKE operator is okay for some purposes, but my users are asking for wildcard characters when they search in Assets(former Insight).

In their previous asset tracking solution, a common task was to search the database with very specific characters as variable, which would return all of a set or a series based on our naming convention. For example:

// code WHERE SerialNo LIKE 'HM-__-51';

or

// code WHERE PropertyID LIKE '01%BFL2%';

Using the LIKE operator would return matches that contain BFL2 anywhere in the field, and not in the exact position desired.

My users are also accustomed to common windows search wildcards such a *.txt or DCIM*.jpg and have asked for similar functionality in Insight's quick search feature.