You might try SELECT OP WITH @ID<=' ', followed by a DELETE. If that don't work then try SELECT OP WITH @ID>'~', followed by a DELETE. That gets rid of all keys with a leading character outside the printable ASCII set, and may get rid of your mysterious record.
Allen Egerton wrote: >From: "Brutzman, Bill" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Friday, December 17, 2004 10:56 AM >Subject: [U2] Data Corruption > > > > >>There lives a new record in our OP table that shows up as INVISIBLE from a >>TCL prompt. >> >> ><snip> > > > >>Suggestions would be appreciated. >> >> > >If your OP table isn't too large, perhaps copying all of the good records to >a new file, clearing the OP file, and copying them back is the fastest >solution. >------- >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/
