Re: convert a decimal number into character

karanbikash@[EMAIL PROTECTED]
 wrote:
> hi ,
> I have a column with datatype as decimal(31,2) . The data is like
> 123456.67  , 7634578.99
> Is it a way to convert the entire number into character . like
> '1232456.67'     .
> 
> The output should not be like as below :
> db2 => select char(decimal(BAL_PRINCIPAL,31,2)) from
> BIKASHK.RPT_BA_PAD331 where
>  integer(Bal_principal)!=0
> 
> 1
> ---------------------------------
> 00000000000000000000010025000.00
> 00000000000000000000010025000.00
> 00000000000000000000010025000.00
> 00000000000000000000010025000.00
> 
>   4 record(s) selected.
> 
> Rather It should be
> 
> 10025000.00
> 10025000.00
> 10025000.00
> 10025000.00
> 
> For the above 4 rows and it should be 'char' in data type.
Just LTRIM or STRIP the leading 0s



-- 
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab