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
