By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE Table mytable(reject_remarks varchar(100))
INSERT INTO mytable VALUES ('Will0017,Will0018, Kind0045 , DGRG0012')
SELECT REGEXP_REPLACE(reject_remarks, '[^0-9,[:space:]]+', '') AS numbers
FROM mytable;
numbers |
---|
0017,0018, 0045 , 0012 |