decimal to numeric conversion

Hi guys,

how do i convert a decimal to numeric data type?

nhoyti:

convert a decimal to numeric data type

what i understood is, you are having a field in database with Decimal datatype and you want to retrieve it as Numeric Field...

you can use CAST() function as..

SELECT CAST(colName AS INT) FROM TABLE

here colName is the Field with Decimal DataType...

hope it helps./.

|||

i have a column in my database which is a decimal... and i want to display the decimal to numeric data type

|||

kaushalparik27:

what i understood is, you are having a field in database with Decimal datatype and you want to retrieve it as Numeric Field...

you can use CAST() function as..

SELECT CAST(colName AS INT) FROM TABLE

here colName is the Field with Decimal DataType...

did you try as above solution ??... i think it will convert Decimal to Numeric DataType...