I am trying to add a zero "0" to the front of my data
and am having trouble accomplishing this

I am trying to make the column look like this;



BEFORE AFTER

DEED DEED
122899 122899
122899 122899
20785 020785
61695 061695
61695 061695
42087 042087
111194 111194

I tried using the LPAD function to no avail
can anybody help me?
scotta