Member Avatar for Mike Bishop

Afternoon All,

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
28.5140299679490
349.893390000000
349.893389892905

I want to format that field so that it only shows the number before the decimal place.

for example
28
249
249

i have tried FORMAT(dbo.VLP_TBL_PM10_7days.[MOP/T], [$#,##0;($#,##0)])but this doesn't work.

I have attatched a screen shoot.

sql.jpg 110.29 KB
  • 2 Contributors
  • 2 Replies
  • 104 Views
  • 23 Hours Discussion Span
  • Latest Post Latest Post by Mike Bishop
Member Avatar for Momerath

Convert(int, dbo.VLP_TBL_PM10_7days.[MOP/T])

Member Avatar for Mike Bishop

thanks thats working as expected.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.