|
<P>How about a more complex statement where you have an "OR" condition?<BR><BR><BR>Paul Nelson<BR>Arbor Solutions, Inc.<BR>708-670-6978 Cell<BR>pnelson@xxxxxxxxxx<BR></P><P> <BR><FONT SIZE=2><B>"Shannon ODonnell" <sodonnell@xxxxxxxxxxxxxxxxx></B></FONT><BR><FONT SIZE=2>Sent by: midrange-l-bounces@xxxxxxxxxxxx</FONT><BR><FONT SIZE=2>06/11/2004 09:16 AM</FONT><BR><FONT SIZE=2>Please respond to Midrange Systems Technical Discussion</FONT><BR><BR> <FONT SIZE=2>To:</FONT> <FONT SIZE=2>"'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx></FONT><BR> <FONT SIZE=2>cc:</FONT> <BR> <FONT SIZE=2>bcc:</FONT> <BR> <FONT SIZE=2>Subject:</FONT> <FONT SIZE=2>Query/400 Upper-Lower Case</FONT><BR> <BR><BR></P><P><FONT FACE="Monospace,Courier">This question came up today, and I'm surprised that after all these years of<BR>programming, that this is something I've not had a reason to investigate<BR>before. But... Using Query/400 (i.e., Runqry *n MyLib/MyFile<BR>RCDSLT(*YES)) on the query selection...is it possible to search for both<BR>upper and lower case letters in a single pass? For example, if I want to<BR>find a record with RNAME='Johnson' and I enter RNAME LIKE '%JOHNSON%'.....<BR>Is there a way to specify that I want to search for both upper and lower<BR>case letters so that it will find 'Johnson' and 'JOHNson', etc...?<BR></FONT><BR><FONT FACE="Monospace,Courier">Just curious...<BR></FONT><BR><FONT FACE="Monospace,Courier">Shannon O'Donnell<BR></FONT><BR><BR><BR><BR><BR><BR><FONT FACE="Monospace,Courier">--<BR>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list<BR>To post a message email: MIDRANGE-L@xxxxxxxxxxxx<BR>To subscribe, unsubscribe, or change list options,<BR>visit: <A HREF=http://lists.midrange.com/mailman/listinfo/midrange-l>http://lists.midrange.com/mailman/listinfo/midrange-l</A><BR>or email: MIDRANGE-L-request@xxxxxxxxxxxx<BR>Before posting, please take a moment to review the archives<BR>at <A HREF=http://archive.midrange.com/midrange-l>http://archive.midrange.com/midrange-l</A>.</FONT></P>
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.