Lawrence Salvucci
asked on
Return Value if NULL condition in SQL Query
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER