Re: Query/400 Upper-Lower Case

<P>How about a more complex statement where you have an &quot;OR&quot; 
condition?<BR><BR><BR>Paul Nelson<BR>Arbor Solutions, Inc.<BR>708-670-6978 
Cell<BR>pnelson@xxxxxxxxxx<BR></P><P>&nbsp;<BR><FONT SIZE=2><B>&quot;Shannon 
ODonnell&quot; &lt;sodonnell@xxxxxxxxxxxxxxxxx&gt;</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>&quot;'Midrange Systems Technical Discussion'&quot; 
&lt;midrange-l@xxxxxxxxxxxx&gt;</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. &nbsp;But... &nbsp;Using Query/400 &nbsp;(i.e., Runqry 
*n MyLib/MyFile<BR>RCDSLT(*YES)) &nbsp;on the query selection...is it possible 
to search for both<BR>upper and lower case letters in a single pass? &nbsp;For 
example, &nbsp;if I want to<BR>find a record with RNAME='Johnson' &nbsp;and I 
enter &nbsp;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' &nbsp;and &nbsp;'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>