How about... SELECT MY.FILE WITH EVAL "INDEX(@ID,CHAR(160),1)" > 1
Mike. -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, May 16, 2013 8:32 AM To: U2 Users List Subject: Re: [U2] Selecting a special character in a SELECT (UV) That didn't work, my telnet program seems to convert most special characters to ^? I tried that first. George -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David A. Green Sent: Thursday, May 16, 2013 10:28 AM To: 'U2 Users List' Subject: Re: [U2] Selecting a special character in a SELECT (UV) Try: ALT-160 Example: SELECT MY.FILE WITH @ID LIKE "...รก..." (By holding down the alt key and pressing 160 on the numeric keypad. David A. Green (480) 813-1725 DAG Consulting -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, May 16, 2013 6:41 AM To: U2 Users Subject: [U2] Selecting a special character in a SELECT (UV) Ok. I'm trying to find all the ID's in a file that contain the character ^160 I tried : SELECT filename WITH @ID LIKE "...^160..." But that didn't work. Aside from writing a program to scan the file, is there a way from TCL? George _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users