Hi All,Do we have function like regexp_substr in postgres..?in oracle this function seach the - from 1 to 2 and return result,regexp_substr(PART_CATG_DESC,'[^-]+', 1, 2)
Maybe one of the functions on this page will get you what you need.
David J.