• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 308
  • Last Modified:

Truncate Numeric Fld

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
mburk1968
Asked:
mburk1968
1 Solution
 
Nathan RileyFounderCommented:
select cast(LOBtotal as int)
from table
0
 
Erick37Commented:
select floor(LOBtotal)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now