Thank you. Yes, I am using Maximo 5.1. I've tried both solutions but continue to get an error in my SQL. My code is below. I only get the error when I add
and maxamr.dbo.workorder.status Not in ('CANCEL', 'COMP', 'CLOSE')
to the where clause (probably syntax)? Any ideas?
SELECT maxamr.dbo.workorder.wonum, maxamr.dbo.workorder.description, maxamr.dbo.workorder.jpnum, maxamr.dbo.workorder.worktype, maxamr.dbo.workorder.status, maxamr.dbo.workorder.calcpriority, maxamr.dbo.workorder.eqnum, maxamr.dbo.workorder.location, maxamr.dbo.workorder.crewid, maxamr.dbo.workorder.supervisor, maxamr.dbo.workorder.targstartdate, maxamr.dbo.workorder.targcompdate, maxamr.dbo.workorder.siteid
FROM maxamr.dbo.workorder
WHERE maxamr.dbo.workorder.siteid LIKE

aram_SiteID and maxamr.dbo.workorder.status Not in ('CANCEL', 'COMP', 'CLOSE')
ORDER BY maxamr.dbo.workorder.targstartdate