Thanks for all the replies. Yeah, it was doing a pattern match, but not one that I would have expected. The "...J1A..." was returning anything with a "J" in F2. I am guessing the "1A" was causing it to think I wanted anything with alpha in it, though I would have thought the 1A would have returned just a single character match, not any length, and how the "J" played into this in conjunction with the pattern match is something I have never seen. However, the syntax I ultimately needed was provided by Ed: "...'J1A'...".
Thanks again to all. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -----Original Message----- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Tuesday, April 14, 2009 2:02 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Select Problem Is it taking 1A as a mask? One Alphanumeric character? How many do you get with "...J..."? Charles Shaffer Senior Analyst NTN-Bower Corporation "Israel, John R." <johnisr...@daytonsuperior.com> Sent by: owner-u2-us...@listserver.u2ug.org 04/14/2009 11:06 AM Please respond to u2-users To: "'u2-users@listserver.u2ug.org'" <u2-users@listserver.u2ug.org> cc: Subject: [U2] Select Problem I have just encountered an inconsistency between the native UniData select and the PICK flavored select. >From a PICK flavored account, it I use the lower case "sselect" to force native UniData syntax, I get: sselect ITMMST WITH F2 LIKE "...J1A..." (6,213 keys - wrong) If I immediately follow this with the PICK select: SELECT ITMMST WITH F2 = "[J1A]" (No keys - correct) These two statements SHOULD return the same results. Interestingly, if I use a less restrictive select (search for J1 instead of J1A), I get the following: sselect ITMMST WITH F2 LIKE "...J1..." (188 keys which is correct) I am guessing that the UniData flavor is treating the J1A as something else, but until I can figure out what it is doing, I can not come up with a work-around. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
