i will try to after 4 decimal point? DECLARE @tbl TABLE (val float) INSERT INTO @tbl SELECT 12.19 INSERT INTO @tbl SELECT 13.92 INSERT INTO @tbl SELECT 14.47 INSERT INTO @tbl SELECT 18.025 INSERT INTO @tbl SELECT 18.3 INSERT INTO @tbl SELECT 17.79 INSERT INTO @tbl SELECT 18.13 INSERT INTO @tbl SELECT 15.245 INSERT INTO @tbl SELECT 12.485 INSERT INTO @tbl SELECT 11.365 INSERT INTO @tbl SELECT 18.26 INSERT INTO @tbl SELECT 15.44 INSERT INTO @tbl SELECT 19.13 INSERT INTO @tbl SELECT 15.59 INSERT INTO @tbl SELECT 28.695 INSERT INTO @tbl SELECT 29.35 INSERT INTO @tbl SELECT 15.27 INSERT INTO @tbl SELECT 15.895 INSERT INTO @tbl SELECT 26.51 SELECT *,((abs(val)*10000) - CONVERT(INT,(abs(val)*10000))),cast(val*power(10,4) as int),val*power(10,4) from @tbl
SELECT *,cast(((abs(val)*10000) - CONVERT(INT,(abs(val)*10000))) as Float), cast(val*power(10,4) as int),val*power(10,4) from @tbl
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)