You should ALWAYS use quotes when searching for literals to ensure you get what you really mean. Just try selecting a file with LIKE ...2A... and with "...'2A'...".
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Darlaston Sent: 25 August 2004 04:32 To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] File Types... You don't need quotes, either single or double. Just use SELECT FILE WITH A LIKE ...AAA... I prefer LIKE to "[AAA]" because you can also do things like SELECT FILE WITH A LIKE ...AAA...BBB... and get all records with AAA followed be some unspecified characters followed by BBB anywhere in field A. Bob Darlaston. -----Original Message----- From: David Jordan [mailto:[EMAIL PROTECTED] Sent: Wednesday, 25 August 2004 10:29 AM To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] File Types... Try "...'AAA'..." David, I can say SELECT FILE WITH A = > "[AAA]" and will find AAA whether at the start, middle or end... That > LIKE "...AAA..." won't do the same - ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
