Lawrence Salvucci
asked on
Remove NULL from results of SQL Query
How can I remove the word NULL from my SQL query results? I have these two columns in my query that return NULL when there is no value. How can I fix this?
CONVERT(Decimal(10, 2), N1.ShippedQty) AS ShippedQty, '$' + CONVERT(varchar(10), CONVERT(money, N1.ShippedQty * S2.funetprice)) AS ShippedAmount
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER