65.9K
CodeProject is changing. Read more.
Home

How to convert nvarchar, money and smallmoney values to int

starIconstarIconstarIconstarIcon
emptyStarIcon
starIcon

4.82/5 (4 votes)

Jun 24, 2011

CPOL
viewsIcon

29226

This tip enables you to convert nvarchar, money and smallmoney values to int.

Simply, we can use the given conversion syntax to convert Nvarchar, smallmoney and money datatype values to int values.
select (CAST(CAST(ColumnName AS float) AS INT))
or
select (CASE WHEN ISNUMERIC(ColumnName)=1 THEN CAST(CAST(ColumnName AS float) AS INT)END )
Illustration Create a table and insert values as:
create table payment(id varchar(5),amount nvarchar(15))
insert into payment values('E001',5000.00)
after that out of "select * from payment" will be id amount --- -------- E001 5000.00 Using Syntax, write code as:
select (CAST(CAST(amount AS float) AS INT)) from Payment
Output for amount columns will be: amount ------- 5000