Posted by Plamen Ratchev on 01/13/08 19:16

Another alternative is using something like this:

SELECT REPLACE(' ' + STR(a/NULLIF(b, 0), 5, 3), ' 0.', '.') AS col_name
FROM TABLE

HTH,

Plamen Ratchev
http://www.SQLStudio.com

• Next in forum: Re: Formatting Numeric Value in Computed Column
• Prev in forum: Re: Queries Log on SQL Server 2000 ???
• Thread view: Re: Formatting Numeric Value in Computed Column

[Reply to this message]