okey... thank you for the help...it is working for me....as you suggested i changed the null values first then applied the first update statement.....
Just for your info i have to use it just for one time as the expected data from then on would be in the proper format...
Thanks again for your valuable input.........
ajongba
Last Activity: Mar 12 '08, 11:49 AM
Joined: Mar 10 '08
Location: Mumbai
-
That is quite fine by me.... I will be looking forward to this.....
Thanks...Leave a comment:
-
I think that would be really helpful if you can show me in detail how to achieve this.....
Thanks alot...Leave a comment:
-
Similar LPAD function in DB2
Hi All,
I am new to DB2 and was just wondering how to update my existing table a column of which has to be left padded with zeros.
Here is the scenerio :-
My table column is a varchar(30) which contains characters ranging from 0(null) to 30 now what i want to do is for those characters whose length is less than 6 should be padded with zero and leave the rest as it is ..also i would like the values to be the same with just the...
No activity results to display
Leave a comment: