Defining Complex Selections
What is the difference between Sign and Option in the following link:
I want to exlcude a range of values ex: exclude 20081001 to 20081020.
In this case what values I shall use for Sign and Option,
I guess OPTION should be equal to NB (Not Between)
but I am not sure about SIGN..
Can some one please help me out?
Naimesh Patel replied
Sign Could have a value from
I - Include E - Exclude
Options could have a value from :
EQ equal to (= Low) NE not equal to (<> Low) BT Between lower and upper value (Low <= x <= High) NB Outside lower and upper value (x < Low und High < x ) CP Contains the pattern NP Does not contain the pattern LT less than than (< Low) LE less than or equal to (<= Low) GT greater than than (> Low) GE greater than or equal to (>=Low)
Combination of the Sign and Option will determine the scope for that Select Option or Range.
E.g. Sign E and Option LT means Exclude where data is less than.