Click here to Skip to main content
Click here to Skip to main content

Tagged as

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 | CS Student | MCTS | CP MVP | Crazy Learner | Dreamer
 
An Indian, who loves his country, believes in freedom, He is an enthusiast Techie and crazy learner. He is passionate about Technologies and social media. He holds bachelor degree of CS in Information Technology and now pursuing Master degree in Computer Application.
 
He always excited and keen Interested in learning and sharing knowledge. He loves to write blog, learn new things, listen music, taking arts and Playing Games..
 
He keep himself on the desk of his imagination, hanging around with some inceptions.
Follow on   Twitter   Google+

Comments and Discussions

 
-- There are no messages in this forum --
| Advertise | Privacy | Mobile
Web02 | 2.8.140827.1 | Last Updated 24 Jun 2011
Article Copyright 2011 by RaviRanjankr
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid