Brady LabelMark 5.0, User Manual

Page: 140 / 186

Data Import/Export
Advanced Options (for importing data).
130
LabelMark 5.0 User’s Manual
Queries
To add specific records of a database or spreadsheet to your labels, you must query the external
data file. Querying is the function used to filter or abstract specific records from the data file
and is presented in the form of 3-part statement consisting of the field containing the data you
want to filter, a relational operator, and the sample data.
Criteria
When building queries, you specify a number of conditions to be met and provide samples of
those conditions. These conditions and samples are called criteria. In order for a record to be
listed in the results, it has to match the criteria.
Relational Operators
Relational operators are mathematical symbols that help state the argument by indicating an
operation on a range of data. The relational operators are:
= Equal to Must match criteria exactly
< > Not equal to Finds everything BUT the sample criteria
> Greater than Finds everything greater than (larger, or occurring after) a
current number or character, but does not include that
number or character
< Less than Finds everything before a specific number or character,
but does not include that number or character
>= Greater than or equal
to Finds the number or character and everything occurring
after that number or character
<= Less than or equal to Finds the number or character and everything occurring
before that number or character
IN In a range of data A logical operator that searches for a range of data within
a field
LIKE Wildcard search for
similar data Finds records with data similar to the supplied criteria
(Use % as wildcard.)