Thanks, Ragnar, You are right in what is happening. The code was supposed to be sending '' but it is sending NULL instead. I see now -- in PostgreSQL to look for any record without the 'X' I have to use a combined condition because a NULL is not included in a != statement.
select count(*) from resource where reengine is NULL or NOT (reengine = 'X') ; *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]