I need to show all the values where DVSN_NM is not null. (Null) shows in the field. I have tried IS NOT NULL and > 0 and < > 0 and nothing seems to work. Please advise. Any ideas appreciated. The column is Characters.
SELECT EMP_ID, SSN_ID, DVSN_NM
AND PLAN_ID IN ('1287')
AND DVSN_NM IS NOT NULL
) C ON A.EMP_ID=C.EMP_ID AND A.SSN_ID=C.SSN_ID