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.
mburk1968Asked:
Who is Participating?
 
Nathan RileyConnect With a Mentor Founder/CTOCommented:
select cast(LOBtotal as int)
from table
0
 
Erick37Commented:
select floor(LOBtotal)
0
All Courses

From novice to tech pro — start learning today.