Originally posted by skid
Maybe C1_REC.group_ofstudy has no Null values but ' ' (blank space).
Nope! It sure has NULL values.


TUNE: U_PORT> select count(*) from u_port.d_hris_academic where group_ofstudy is null;

COUNT(*)
----------
40

1 row selected.

TUNE: U_PORT>
Now what ?