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

This question already has answers here: Closed 11 years ago.

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!

---

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