 |
|
| S/List User Manual
|
| Equal To | = | Select records where the column value is equal to a certain value | | Not Equal To | # | Select records where the column value is not equal to a certain value | | Greater Than | > | Select records where the column value is greater than a certain value | | Greater Than Or Equal To | >= | Select records where the column value is greater than or equal to a certain value | | Less Than | < | Select records where the column value is less than a certain value | | Less Than Or Equal To | <= | Select records where the column value is less than or equal to a certain value | | Starting With | ] | Select records where the column value begins with a certain value | | Ending With | [ | Select records where the column value ends with a certain value | | Containing | [ ] | Select records where the column value contains a certain value | | Between | … | Select records where the column value is between two values |
Table 4: The Comparison Operators
|
| MD4 | A 4-Place decimal number | 15000.0506 | | MD0, | An Integer with commas | 40,550,120 | | MD2,£ | 2-Place decimal Sterling amount | £510.99 | | D | Date, default medium format | 08 OCT 2001 | | D2/ | A 2-Digit date, MM/DD/YY | 10/08/2001 | | D.E | European date, DD.MM.YYYY | 08.10.2001 | | MTS | 24-Hour time with seconds | 13:10:01 | | MTH | 12-Hour time with AM/PM | 1:10PM | | DT | Date and Time | 08/10/2001 13:10:01 | | B | Boolean (True/False) | 'Yes' or 'No' | | [PROGRAM] | A user-defined program that carries out the data conversion | |
Table 5: Conversion Patterns for Output
 This list is not exhaustive.
|
| Text | Break here! | Use text to substitute the *** (three asterisks) normally printed at the break. | | D | 'D' | Suppresses redundant totals by suppressing the break data line if the preceding data column contains only one line of data. | | L | 'L' | Suppresses the blank line that precedes the break data line. | | P | 'P' | Performs a page-break for each column break. | | V | 'V' | Prints %value% at the break line, where %value% is the value of the breaking column. |
An example combination | 'L' 'P' Value is: 'V' | This combination suppresses the blank line that precedes the break data line, performs a page-break for each column break, and prints "Value is: %value%" at the break line, where %value% is the value of the breaking column. |
Table 6: Break-On Options |
| L | "'L'" | Suppresses the blank line that precedes the break data line. | | P | "'P'" | Prints the Grand Total on a new page. | | U |
"'U'" | Underline, except that the line is above the Grand Total (overline), separating it from the data. | | UU | "'UU'" | Underline and overline the Grand Total. |
An example combination | "Grand Total 'UU'" | This combination prints the text "Grand Total" and under each grand-totalled column, the value is underlined and overlined. |
Table 7: Grand-Total Options
[top]    
|  | |  |
