try to use "Case When" in your StoredProcedure
SELECT
ItemName,
(CASE SerialNumber WHEN '' THEN '0'
ELSE SerialNumber END) as SerialNumber
FROM Items
we force to override the SerialNumber field to zero because we put Conditional statement
please vote and Accept solution