PL SQL subquery question

[ecka00]

i have a table (phsload) with 160 records and when i run the following query i receive a resultset of 3 records.

select "UUID", "GUID" from CCDBA.phsload
where TO_CHAR(UUID) IN
(SELECT TO_CHAR(USER_UID) FROM PORTAL.USERGROUPMEMBERSHIP);

however when i ask for the opposite and add NOT IN i receive a nullset--it should return the other 157 records. PLEASE HELP!!!

select "UUID", "GUID" from CCDBA.phsload
where TO_CHAR(UUID) NOT IN
(SELECT TO_CHAR(USER_UID) FROM PORTAL.USERGROUPMEMBERSHIP);

[skhanal]

Are there NULL values in USER_UID?

Also make sure that the TO_CHAR(UUID) and TO_CHAR(USER_UID) are same length, or use RTRIM.