correct way to sparch for all codes falling between the values 

 "020000" and "030000." 



INCORRECT: C0DE>20000 .AND. C0DE<30000 



CORRECT: VAL(C0DE)>20000 .AND. VAL{C0DE)<30000 



Conversion from Numeric to Character. 



To convert a numeric value to a character string, use the "STR" 

 function, e.g., STR(EAGLE). 



The string returned actually has ten characters to the left of the 

 decimal, so if you wish to search for an exact match, you must select 

 a substring of the string. For example, the following two operations 

 involving the one-digit numeric field "EAGLE" are equivalent. 



EAGLE=2 



SUBSTR(:)TR(EAGLE) ,10,1) = "2" 



Parentheses. 



Make sure that all multiple conditions are enclosed in parentheses, 

 and that all pairs of parentheses match. If there are unmatched 

 ■ parentheses, the query will not work. The following is an example of 

 a faulty and a corrected complex query condition: 



INCORRECT: VAL(SUBSTR(C0DE,1 ,2)<10 .AND. "YELL" $UPPER(COUNTIES) 



CORRECT: VALISUBSTR(C0DE,1 ,2) ) <10 .AND. "YELL" $UPPER(COUNTIES) 



3.3. Report Formats and Report Order 



After the completion of the query condition input, you are 

 allowed to specify the Report Format and Report Order. Again, the 

 display will allow you an array of choices. 



Fig. 3-12: The Report Order Menu 



3-11 



