I have a query that is supposed to grab any record that has a status not equal to 'Removed'. The status can be 'Approved', 'Interested', 'Removed' or simply empty. With the query below, it's not returning the ones that are designated empty, though it seems to me that it should. Status is not a required field so it'll often be empty.
SELECT service_population,agency,city,state,int_agency_id, ROWNUM AS r, COUNT(agency) OVER() AS rowcount FROM internships WHERE 1=1 AND dept = 'knes' AND status <> 'Removed' ORDER BY UPPER(agency) ASC So why isn't it showing these records? thanks. -- Daniel Kessler University of Maryland College Park School of Public Health Suite 2387 Valley Drive College Park, MD 20742-2611 Phone: 301-405-2545 http://hhp.umd.edu ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285819 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4