SQLTeam.com | Weblogs | Forums

How to correct this number


i have a number like 20.000 in sql server and it is actually 20 not 20.000
do you know how i can remove 000 from this number
i don't know if it a setting
i use these numbers in ms access
do you know how i can change them?
thank you

select FLOOR(20.000)

CAST(column_name AS int) AS column_name