Numeric Format

Hi Fellow Listers,

I have a formatting problem. I would like a 19 digit number formatted with dashes. I have defined the format on the universe side as follows: 0000-0000-0000-0000000

If the leading numbers are zeroes - I want to see them! This works fine if the numbers are less than 16 digits. I get 0001-1234-1234-1234567 for example. If the number has another digit I start to see scientific notation. For example: 1.234567891234567E+18. I DO NOT want this. I have tried removing the formatting etc. but at a certain decimal point, BO reverts to scientific notation! Any Ideas?

Thanks,
Chris Lovejoy
IBM Global Services
Phone: (916) 567-2960
Pager: (916) 948-0047
E-Mail: clovejoy@us.ibm.com


Listserv Archives (BOB member since 2002-06-25)

In your select statement convert the data to character format. Simon


Listserv Archives (BOB member since 2002-06-25)