How can I modify this CASE WHEN statement when the value is NULL? I need to show '01' instead of the records returning an NULL value.
Right now some records show a result of NULL and I want to have it show '01' instead of NULL
CASE WHEN ISNULL(P.MinProdCL, '')
= '' THEN P2.MinProdCL ELSE P.MinProdCL END AS NewProdCLFinal