Text-In Query Examples

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

Document 800-00919 Rev F

121

02/08