>select data from numeric field in formatted manner like number of decimals for float.
>Rajesh
SELECT CAST(MyFloatField AS N(10,2))
But I prefer to manage such things in my frontend side.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.