Exists any function that returns the value without zeros of a field decimal.

Example:

select function(a.cantidad) as cantidad from tabla a

Value Result

3.0000 3

3.0100 3.01

3.0210 3.021

3.0004 3.0004

Thanks and Excuse the simplicity of the question but I do not find anything than accomplish such operation.
=========
¦¦ ISMAEL ¦¦
=========
"Oír o leer sin reflexionar es una ocupación inútil".
Confucio (551-479 a. C.); filósofo chino.


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