Thanks to both of you. All three solutions work for my query.

Taking this a step further, what if I do not want to see the jNMBR and sNMBR at all when cDate is NULL? In other words, this would be the result:

jNMBR sNMBR

7545 1000

8000 1001

8011 1003

9578 1004

(the jNMBR 8000 sNMBR 1002 row is not shown because cDate is NULL)