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
