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

Forgot to note that if negatives are expected, then it needs one more nested
REPLACE:

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

Plamen Ratchev
http://www.SQLStudio.com

• Next in forum: error when connecting to sql db
• Prev in forum: Re: Formatting Numeric Value in Computed Column
• Thread view: Re: Formatting Numeric Value in Computed Column

[Reply to this message]