Re: query with regular expression

2019-01-03 Thread Glenn Schultz
Thanks for the tip! On Thu, Jan 3, 2019 at 12:58 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Thursday, January 3, 2019, Glenn Schultz wrote: > >> All, >> >> I am writing a query to select * from where ~ '[regx] an example of the >> sting that I am matching is below >> >> FHLG

Re: query with regular expression

2019-01-03 Thread David G. Johnston
On Thursday, January 3, 2019, Glenn Schultz wrote: > 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