How to remove trailing zeros using Sybase SQL?

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., Mar 03 '11 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, Mar 03 '11 at 18:01
and how can I make that automatically? sometimes has 3 decimal zeros, other times 6.. — aF., Mar 03 '11 at 18:23
@aF for this particular problem, MSSQL = Sybase for all intensive purposes — RichardTheKiwi, Mar 03 '11 at 18:39

score 1 · Accepted Answer · answered Mar 03 '11 at 18:40

1

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

answered Mar 03 '11 at 18:40

JNK

1 Answers1