Need to remove only characters at the end.
GFG2014JP34343
D2013GH43422
HHH2014JP34343
CC2013GH43422
Output:
2014JP34343
2013GH43422
2014JP34343
2013GH43422
Tried REGEXP with different pattern
>Solution :
We can use a regex replacement here:
SELECT val, REGEXP_REPLACE(val, '^[^[:digit:]]+', '') AS val_out
FROM yourTable;