Create an I-type dictionary item to do an INDEX on CHAR(160) and select on that.
Dan McGrath Managing Director, U2 Servers Lab Rocket Software 4600 South Ulster Street · Suite 1100 · Denver, CO 80237 · USA T: +1 720 475 8098 · E: [email protected] · W: u2.rocketsoftware.com -----Original Message----- From: [email protected] [mailto:[email protected]] 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: [email protected] [mailto:[email protected]] 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: [email protected] [mailto:[email protected]] 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 [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
