Minor request but it would be good if there was either a way to select or pattern match the beginning of a search term. The 'Like' pattern matching works great but I note that when searching for the prefix we use for vendor code, just by sheer dumb luck some of them are common enough that they appear elsewhere in product codes (the prefixes are unique to vendor but the letters like 'TH' may occur beyond the 2 or 3 digit prefix in the product code ie XYZ-200-22TH-G).
So a simple 'Starts with" search of product codes with say 'TH-'
I use the Like and Not Like comparators a lot so a 'start' pattern match indicator would also work. ie '^TH-'
EDIT: Well that's embarrassing (again). I no sooner ask a question than I find a solution. It looks like searching for a term 'TH-' with the % at the end ie 'TH-%' does find just the beginning terms. Yeesh sorry.
So a simple 'Starts with" search of product codes with say 'TH-'
I use the Like and Not Like comparators a lot so a 'start' pattern match indicator would also work. ie '^TH-'
EDIT: Well that's embarrassing (again). I no sooner ask a question than I find a solution. It looks like searching for a term 'TH-' with the % at the end ie 'TH-%' does find just the beginning terms. Yeesh sorry.