Click here to Skip to main content
13,050,896 members (70,180 online)
Click here to Skip to main content
Add your own
alternative version

Tagged as

Stats

17.2K views
4 bookmarked
Posted 24 Jun 2011

How to convert nvarchar, money and smallmoney values to int

, 24 Jun 2011
Rate this:
Please Sign up or sign in to vote.
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

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

RaviRanjanKr
Software Developer
India India
Microsoft Student Partner | MCTS | CP MVP | Crazy Learner

An Indian, who loves his country, believes in freedom, He is an enthusiast Techie and crazy learner. He is passionate about Technologies. He holds Master in Computer Application and Bachelor degree of CS in Information Technology.

He always excited and keen Interested in learning and sharing knowledge. He loves to learn new things, listen music, taking arts and Playing Games..

You may also be interested in...

Comments and Discussions

 
-- There are no messages in this forum --
Permalink | Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.170713.1 | Last Updated 24 Jun 2011
Article Copyright 2011 by RaviRanjanKr
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid