how to get decimal part in sql server
Jak
858
Points
132
Posts
|
how to get decimal part in sql server? |
Answers
NiceOne...
1382
Points
14
Posts
|
Hi, You can use Floor Method as: SELECT Value - FLOOR(Value)
SELECT 100.123 - FLOOR(100.123)
Posted On:
16-Feb-2015 23:49
|