All,
I am writing a query to select * from where ~ '[regx] an example of the
sting that I am matching is below
FHLG16725
The first two alpha characters to match are FN, FH, GN any alpha characters
between those and the numeric don't matter as the first two alpha + numeric
will create a unique.
reading the docs I am pretty sure I need to use ~ for bracket expression
I tried '^[FN-FG-GN][0-9]' but does not seem to work. I have to admit I am
weak on regex - never quite seem to be able to get it through my coconut.
Any help would be appreciated,
Glenn