-
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
J.Scott Adams
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|