Regular Expression non-greedy quantifiers not working

General

Regular Expression non-greedy quantifiers not working

Hi guys, 

Please give me some help if you know the answer:

In the regex pattern below, the code should return HELLO instead of HELLO23 if the non-greedy version of \d{3,}? works, but it didn't work that.   can anyone show me how to do non-greedy pattern on TD14.

SELECT 'HELLO23456' AS ADDR,

regexp_replace( ADDR ,'\A(([A-Z]|24|7|76|99|9|365|84)[\w\s-&\.\'']+)(\d{3,}?)','\1' ,1 ,1 ,'i') as ADDR_GROUP;

Thank you

Kin

Tags (1)