How to eliminate digits after decimal point

Answers

• 

  

  1

  Sign in to vote

  use cast function to avoid decimals

  Select cast(sal as decimal (10,0)) from emp

  • Proposed as answer by sekhara shiris chinta Monday, June 21, 2010 1:42 PM
  • Marked as answer by Ed Price - MSFTMicrosoft employee Tuesday, April 16, 2013 5:11 PM

  Monday, June 21, 2010 1:07 PM
• 

  

  1

  Sign in to vote

  If that data is a string you could do this:  

  select Left(YourColumName,Len(YourColumName)-3) 
  
  from dbo.tableName

  Seth

  ---

  http://lqqsql.wordpress.com

  • Marked as answer by Ed Price - MSFTMicrosoft employee Tuesday, April 16, 2013 5:11 PM

  Monday, June 21, 2010 2:36 PM
• 

  

  1

  Sign in to vote

  Hi,

  Try with the following query.

  Select REPLACE(colname,'.00', '' from tblname

  ------------------------

  Thanks,

  RajaSekhar Reddy . K

  • Marked as answer by Ed Price - MSFTMicrosoft employee Tuesday, April 16, 2013 5:11 PM

  Monday, June 21, 2010 4:45 PM