[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Truncate Numeric Fld

Posted on 2010-11-12
2
Medium Priority
?
304 Views
Last Modified: 2012-05-10
I have a SQL Tbl with the fld  LOBtotal which is Numeric 18,2. I want to truncate the decimal so that a number that currently displays as 178.55 looks like 178. I do not wish to round. I simply want to drop everything starting with the decimal.
0
Comment
Question by:mburk1968
2 Comments
 
LVL 12

Accepted Solution

by:
Nathan Riley earned 2000 total points
ID: 34123026
select cast(LOBtotal as int)
from table
0
 
LVL 32

Expert Comment

by:Erick37
ID: 34123035
select floor(LOBtotal)
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Loops Section Overview
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question