hi, friends, Our phone number format is 11 digital, i want to replace last 4 digital into star, for example: Replace this string including 11 digital phone number: '18910180000,13910180000,232,abc' into: '1891018****,1391018****,232,abc' I try to use: select regexp_replace('18910180000,13910180000,232,abc','[0-9]{7}(\d+)','****','g') But it doesn't work, it will return: "****,****,232,abc" Can anyone help me? Thanks a million!
Best Regards peng