Beermann, Albert wrote > > Hello Everybody ! > > In my table I have fixed(8,2) columns ! > In my application I need all values in an fixed format nnnnnn.nn > I tried select fixed(a,5,2),fixed(b,5,2) from ... > But the result show only 2 decimal places if the value has decimal > places ? > 5 5.5 7.77 3 > > I need > 5.00 5.50 7.77 3.00 > > >From a private mail I know that you are using ODBC. I do not know why ODBC outputs the values like this (got no info so far). But a workaround can be:
Lfill (chr (a), ' ', 10) Then the database kernel will prepare a character value and the output does not depend on client/tools and their versions. Elke SAP Labs Berlin > > Any help welcomed > Albert > > ''''' > ''''''''' > (0 0) > +---------oOO-----------(_)------------------------------+ > | Tel: 0541/5841-868 | > | Fax: 0541/5841-869 | > | Mail: mailto:[EMAIL PROTECTED] | > | Internet: http://www.piepenbrock.de | > +--------------------------------------oOO----------------+ > |__|__| > || || > ooO Ooo > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
