>SELECT 'A', * FROM \pro50\apdata\apvend18 vv ; >WHERE vendno = '000463' ; >INTO CURSOR curAdds > >SELECT 'D', * FROM \pro50\apdata\apvend18 vv ; >WHERE vendno = '000687' ; >INTO CURSOR curDeletes > >SELECT * ; >FROM curAdds; >UNION ; >sele * ; >FROM curDeletes; >INTO CURSOR zzzz >
>SELECT ICASE(vendno = '000463', 'A', vendno = '000687', 'D', ' ') AS MyField, vv.* ; >FROM \pro50\apdata\apvend18 vv ; >WHERE INLIST(vv.vendno, '000463', '000687') >INTO CURSOR zzzz >Yes it would, but I was just trying to illustrate a larger problem I had where I was forced to use UNIONs