I have been looking for information on this, and can't get a clear answer. I am developing an ASP site using an Access database, and eventually, I will be ...

I had the fields set to be a data type of money, and was planning on the values including zero. ... is there a way to get SQL Server 2000 to return 0.00 as the value instead of .00?