I have a report that uses SQL 2008 database. It is a money field. I do not want the decimal or the $ sign to show. If it has cents like 1.50 I want it to appear as 150 if it is just 1.00 I want is to be 100. How do I accomplish this?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!