field = ''It will work in VFP as well with SET ANSI ON.
>>>Select >>> Case When Empty(Activejobitems.part_no) Then >>> Activejobitems.description >>> Else Activeparts.description End as description >>>From JobItems >>>Activejobitems Inner Join Jobs Activejobs On Activejobitems.job_num = Activejobs.job_num >>>Left Outer Join parts Activeparts On Activejobitems.part_id = Activeparts.id Inner >>>Join schedule On Activejobitems.job_num = ScheduleRecords.job_num >>>Inner Join machines On ScheduleRecords.mach_num = Machines.mach_num >>>Where ScheduleRecords.mach_num = ' ' AND >>> ScheduleRecords.status <> 'C' AND >>> Activejobs.status = 'A' >>>Order By [ScheduleRecords].[mach_num] , [ScheduleRecords].[order_mach] >>>