How to get 4 digit numbers after decimal including before decimal also in SQL

Question

I have a data that is101.32650000 and I want to get 101.3265 only ... I tried using right function, but the disadvantage is that digits before decimal can vary.

Answer 1

How about using cast with decimal and scale of 4. Something like:

select cast(101.32650000 as decimal(10,4));

• SQL Fiddle Demo