How to remove trailing zeros using Sybase SQL? [duplicate]

Question

Possible Duplicate:
Remove trailing zeros from decimal in SQL Server

I have a column DECIMAL(9,6) i.e. it supports values like 999,123456.

But when I insert data like 123,4567 it becomes 123,456700

How to remove those zeros in sybase SQL?

Using this didn't work!

I allready said that those answer dodn't work.. SQL Server != Sybase SQL. — aF.
– aF., Commented Mar 3, 2011 at 17:57
@aF: The accepted answer to that question says "...do this in the presentation layer." Is there something in your presentation layer that prevents you from being able to do this? — Joe Stefanelli
– Joe Stefanelli, Commented Mar 3, 2011 at 18:01
and how can I make that automatically? sometimes has 3 decimal zeros, other times 6.. — aF.
– aF., Commented Mar 3, 2011 at 18:23

JNK · Accepted Answer · 2011-03-03 18:40:32Z

1

Do it in your application/presentation layer. SQL is not the place to do cosmetic changes like dropping trailing zeroes.

answered Mar 3, 2011 at 18:40

JNK

65.5k15 gold badges127 silver badges139 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1