By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select idNumber, stuff(idNumber, 1, patindex('%[0-9]%', idNumber) - 1, '')
from (values ('1430112345679'), ('PO02456977785'), ('C035343542654'), ('QPD1236548')) v(idNumber)
| idNumber | (No column name) |
|---|---|
| 1430112345679 | 1430112345679 |
| PO02456977785 | 02456977785 |
| C035343542654 | 035343542654 |
| QPD1236548 | 1236548 |