Hi gurus,

My problem is as follows:



I have a Numeric field ARTICLE_NBR of length 9.

Some of the articles are of length less than 9.

Suppose mys article no is : 123456

In my output I need it as : 000123456.



I need a query for this urgently.

Please if anyone can help me........







Regards

Chiranjeev

N

'We Stop playing not because we grow old,we grow old because we stop
playing'




DB2 & UDB email list listserv db2-l LazyDBA home page