This might be the long way but something like;
SELECT OP WITH @ID GT 'SOMEVALUE TO SELECT ALL BUT THE BAD REC' TO A SELECT OP TO B GET.LIST A TO 1 GET.LIST B TO 2 MERGE.LIST 2 DIFF 1 TO 0 SAVE.LIST C ;* should be just the bad record here GET.LIST C COPY FROM OP TO &HOLD& OVW DELETING Anthony -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Friday, December 17, 2004 10:56 AM To: '[EMAIL PROTECTED]' Subject: [U2] Data Corruption There lives a new record in our OP table that shows up as INVISIBLE from a TCL prompt. Without luck, I tried the commands... >DELETE OP ^251 >DELETE OP ^255 I looked at the file using EditPlus. Of course, there are many special characters that appear. Suggestions would be appreciated. --Bill ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
