<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7226.0">
<TITLE>Download question regarding the use of EVAL with a multi-valued field.</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">I am trying to 'sort' the order of the values in a multi-valued field so that all of the 'APPLES' values will be in one column, all of the 'ORANGES' values in the next etc. (The Fruit values, of which I can have up to 5, could have been loaded into the STUDENTS file in the multi-valued field in any sequence.)</FONT></P>
<P><FONT SIZE=2 FACE="Arial">DOWNLOAD STUDENTS @ID N12.FRUIT NUM.VALUES 5 EVAL "IF N12.FRUIT LIKE '…APPLES…' THEN 'APPLES' ELSE ' '" EVAL "IF N12.FRUIT LIKE '…ORANGES…' THEN 'ORANGES' ELSE ' '" ….etc</FONT></P>
<P><FONT SIZE=2 FACE="Arial">I am not getting any values returned in my EVAL fields. (I've tried exchanging LIKE for EQ & removing the ' …'s but the results are the same.)</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Is EVAL on a multi-valued field supported in DOWNLOAD ?</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Thank you for your help.</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">(We are using Download Version 7.11.)</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Maggie Steyn</FONT>
<BR><FONT SIZE=2 FACE="Arial">Application Analyst</FONT>
<BR><FONT SIZE=2 FACE="Arial">Information Technology Department</FONT>
<BR><FONT SIZE=2 FACE="Arial">Niagara University</FONT>
<BR><FONT SIZE=2 FACE="Arial">msteyn@niagara.edu</FONT>
<BR><FONT SIZE=2 FACE="Arial">Phone: (716) 286-8651</FONT>
<BR><FONT SIZE=2 FACE="Arial">Fax: (716) 286-8045 </FONT>
</P>
<P><FONT SIZE=2 FACE="Arial"> </FONT>
</P>
</BODY>
</HTML>