Maybe create a new dictionary that concatenates the multiple attributes together, and do UPCASE(), then you can keep your Select statement as is.
Mark -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Brutzman, Bill Sent: Friday, March 13, 2009 7:40 AM To: [email protected] Subject: [U2] - UniBasic String Search I need to examine fields for perhaps one thousand part.numbers looking for tech specs that contain character strings like "MIL" "Spec" "SPEC" "-14" etc While I can do this with commands like... execute 'SELECT IM WITH OP.SPEC LIKE "...-14..." ', this technique is awkward since I have a few dozen strings to look for... ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
