SQL Queries

*****************************************************************

To Set column values as empty which contains zeros

SELECT (case when quantity = 0 then '' else quantity end) AS 'quantity'
FROM stock