Link to home
Start Free TrialLog in
Avatar of ayen
ayen

asked on

user function in sybase

Hi,

we are using sybase 11.5 Ver. we have a req.
in which we have to expose one of numeric data  with turnctaed trailing zero's.

for eg: If we have 0.87900000 . This should be displayed as 0.879
0.88756000 as 0.88756 and 0.88000000 as 0.88

Pls let us know how we can go ahead.

Thanks

Raj
ASKER CERTIFIED SOLUTION
Avatar of bret
bret
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
My concern there is that I don't think the behavior leaving off trailing
zeroes is documented - and so could possibly change.  While simply
converting to a string currently works, wouldn't it be better to have
more bulletproof code?

-bret
Avatar of ChrisKing
ChrisKing

well you would know that sort of thing more than us