I have part of a SQL statement that will search out records that have a particular field as empty, or containing a 0. It is as follows:<BR><BR>or (trn_emp_course.cs_expire is null)<BR><BR>Now I only want to get fields that have a 0. I have tried <BR><BR>or (trn_emp_course.cs_expire is 0)<BR>or (trn_emp_course.cs_expire = 0)<BR>or (trn_emp_course.cs_expire = &#039;0&#039;)<BR><BR>Can&#039;t get it to work. Any suggestions?