SQLServerCentral » Latest topics
0 or $0.00 instead of NULL?
[code language="sql"]SELECT
'$' + CONVERT(VARCHAR(12), SUM(CAST([ie].[AMOUNT] AS MONEY)))[/code]
I tried this:
[code language="sql"]
'$' + CONVERT(VARCHAR(12), SUM(CAST([ie].[AMOUNT] AS MONEY)))[/code]
I tried this:
[code language="sql"]
No comments:
Post a Comment