Thread: Remove decimal places

I am working on microsoft OLE DB Provider for SQL Server.I am facing one of the problem for particular 1 field.

expamle ABC=234.56

I wanted to remove the decimal places. i want to display only
ABC=234

please help me out for the issues.

Thanks in advance.

Rohit

What is the logic that you want to implement ?

Is it round off or simply truncate what ever is after decimal.

Hi Rohit,

You can use ROUND ( numeric_expression , length [ ,function ] ) function of SQL Server like below:
Select Round(ABC,0)

It will give you the rounded off value till decimal point.


--V V--
Vikas Vaidya

Originally Posted by rohit_k77

I am working on microsoft OLE DB Provider for SQL Server.I am facing one of the problem for particular 1 field.

expamle ABC=234.56

I wanted to remove the decimal places. i want to display only
ABC=234

please help me out for the issues.

Thanks in advance.

Rohit

Hi Rohit

Eg:select trunc(1234.456,0) from dual;

This way u can remove decimals by using (TRUNC) function

Hi Rohit

Eg:select trunc(1234.456,0) from dual;
Ans: 1234

This way u can remove decimals by using (TRUNC) function