Text-in query examples b, Query example i, Text-in query examples – Honeywell HRSD4 User Manual
Page 121

Text-In Query Examples
Document 800-00919
Rev F
121
02/08
B
Text-In Query Examples
Query Example I
1
2
3
4
5
6
123456789012345678901234567890123456789012345678901234567890
Item
Unit price
Qty
amount
==============================================
Coke
| $ 2.20 |
1(s) |
$
2.20
Fanta
| $ 2.20 |
1(s) |
$ 2.20
Hotdog
| $ 3.50 |
3(s) |
$ 10.50
Pepsi
| $ 1.95 |
1(s) |
$
1.95
==============================================
total : $ 16.85
Thank you~~
In the above text-in data, you can find that the comparison value is located at 17th (Unit
price, $ mark will be ignored automatically), 28th (Qty) and 40th (amount) characters
(including spaces) from the left. In this case, you can enter 17, 28, and 40 in each
Column field.
For example, if you want to search for Coke with a Qty (Quantity) of more than 1 and
Hotdog with an amount totaling over $8, the following search condition can be set.
Figure B-1
Text-In Query Example 1