On Thu, Oct 15, 2015 at 8:32 AM, Ramesh T <rameshparnandit...@gmail.com> wrote:
> select position('-' in '123-987-123') > position > --- > 4 > But I want second occurrence, > position > ------------- > 8 > > plz any help..? > > SELECT length((regexp_matches('123-987-123', '(\d{3}-\d{3}-)\d{3}'))[1]) David J.