Hi Guys,

I'm on a tight deadline and don't have much time to go through the archives,
so I apologise if this questions has been asked before...

I have a table with a double precision field called INCR_PREM_ADDITIONAL
which holds a premium increase percentage....
I would like to return in a SP a description field like...

SHORT_DESCR = 'CPI Plus' || cast(INCR_PREM_ADDITIONAL as varchar(10)) || '%'

And my output should look like "CPI plus 3.5%"...but I'm getting "CPI plus
3.5000000%"....

How do I do a straight forward convert from the double precision to the
varchar without the trailing 0's to pad the varchar?

TIA
Steve



[Non-text portions of this message have been removed]