CODE EXAMPLE FOR SQL

postgres extract number from string

SELECT NULLIF(regexp_replace(po_number, 'D','','g'), '')::numeric AS result
FROM   tbl;