It's because 1A means one numeric character. If you surround the literal in single quotes it'll work fine:
sselect ITMMST WITH F2 LIKE "...'J1A'..." (6,213 keys - wrong) Ed -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Israel, John R. Sent: 14 April 2009 17:07 To: '[email protected]' 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 [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------------------------------------------------------------------------------------------- Please remember to recycle wherever possible. Reduce, reuse, recycle, think do you need to print this e-mail? ------------------------------------------------------------------------------------------- This e-mail and any attachment(s), is confidential and may be legally privileged. It is intended solely for the addressee. If you are not the addressee, dissemination, copying or use of this e-mail or any of its content is prohibited and may be unlawful. If you are not the intended recipient please inform the sender immediately and destroy the e-mail, any attachment(s) and any copies. All liability for viruses is excluded to the fullest extent permitted by law. It is your responsibility to scan or otherwise check this email and any attachment(s). Unless otherwise stated (i) views expressed in this message are those of the individual sender (ii) no contract may be construed by this e-mail. Emails may be monitored and you are taken to consent to this monitoring. Civica Services Limited, Company No. 02374268; Civica UK Limited, Company No. 01628868 Both companies are registered in England and Wales and each has its registered office at 2 Burston Road, Putney, London, SW15 6AR. ------------------------------------------------------------------------------------------- ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
