Link to home
Create AccountLog in
Avatar of bibi92
bibi92Flag for France

asked on

format result table size

Hello,


With below query the result is 32,863.00, I search to remove .00 for having 32,863


SELECT CONVERT (varchar(20), CAST(DBSizeMB as MONEY), 1)from [tsize]

  

Thank you


Regards 

Avatar of Noah
Noah
Flag of Singapore image

Hi!

This should remove the decimal places and display the result as an integer value.

SELECT CAST(CAST(DBSizeMB as MONEY) as int) from [tsize]

Open in new window




Avatar of bibi92

ASKER

Hello,


Thank you but I search having 32,863 and not 32863 

ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Apologies. @slightwv's recommendation should give you the result you're looking for.