How to convert nvarchar, money and smallmoney values to int






4.82/5 (4 votes)
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 PaymentOutput for amount columns will be: amount ------- 5000