I am using the below query to get total amount after a discount.

My issue is when the discount is equal to zero, the total amount becomes zero.

How can I resolve this issue?

```
SELECT  
    CAST(SUM(Quantity * UnitPrice * (Discount / 100)) AS varchar(50))  
FROM
    Stock_Purchase_Details

```