hope someone can help as this is really doing my head in.
I have a SQL View which has a field called MOP/T which shows the number like so
I want to format that field so that it only shows the number before the decimal place.
i have tried FORMAT(dbo.VLP_TBL_PM10_7days.[MOP/T], [$#,##0;($#,##0)])but this doesn't work.
I have attatched a screen shoot.