WHERE (CardCode LIKE '%' + @CardCode + '%' OR @CardCode IS NULL)
WHERE (CardCode LIKE '%' + @CardCode + '%' OR CardCode IS NULL)