'123-987-123' it is not fixed some times it may be '1233-9873-123-098' as you said it's fixed,
changes the values in middle of the - sometimes times i need 1233 and 098 or 9873,first position i'll find direct for second variable we don't know where it's end with - i.e , i need to find second postition of the variable between the '-' On Thu, Oct 15, 2015 at 6:32 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > 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. > >