Thread: db2-- Decimal to Varchar without leading zeros
View Single Post
  #2 (permalink)  
Old 04-29-03, 17:36
chuzhoi chuzhoi is offline
Registered User
  
Join Date: Dec 2002
Posts: 134
Re: db2-- Decimal to Varchar without leading zeros
One of the ways is char and rtrim combo
values rtrim( char ( 1.2345 ) )

You need rtrim to remove trailing spaces
Reply With Quote