Click here to Skip to main content
14,269,359 members
Rate this:
Please Sign up or sign in to vote.
See more:
Dear expert,

How do you handle INT in sql server 2008


SELECT IDNO, INT(ARREARS) AS COMP_ARREARS FROM TRIAL


Please assist


Thanks

What I have tried:

I have checked on the Internet and reviewed my notes
Posted
Updated 4-Apr-16 18:21pm
Comments
Karthik_Mahalingam 5-Apr-16 0:17am
   
you want to cast to int?

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

Try this
SELECT IDNO, cast(ARREARS as int) AS COMP_ARREARS FROM TRIAL

refer these links:
CAST and CONVERT (Transact-SQL)[^]
SQL SERVER - Convert Text to Numbers (Integer) - CAST and CONVERT[^]
SQL Server: CAST Function[^]
   

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




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100