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

cast(col_name as decimal(28,4)) as col_name

Answer 2

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

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

• SQL Fiddle Demo

Answer 3

SELECT CAST(101.32650000 AS DECIMAL(10,4));