2011

DescriptionOperator
The value of the selected property or data contains the value you
enter in the Value box. Applies to string (character) data types
LIKE
only. Use the percent sign (%) as a wild-card character. For ex-
ample, to retrieve all objects that have a value starting with B,
choose the LIKE operator and enter B% in the Value box. For in-
formation on the wild-card characters supported by your database
system, refer to the documentation for your database system
software.
Value box
Specify the value to search for.
The value must match the data type of the column.
If the string contains a single quotation mark, precede the single quotation
mark with another single quotation mark.
For dates, use the format TIMESTAMP'YYYY-MM-DD 00:00:00', for example,
TIMESTAMP'1993-06-20 11:24:00'.
To use wild-card characters with string values, use the LIKE operator. For
example, to retrieve all objects that have a value starting with B, choose the
LIKE operator and enter B%. Refer to the documentation for your database
software to see which wild-card characters are supported.
Add Condition
Add the condition line to the Current SQL Condition list.
The new line is added to the bottom of the list. If any line in the list is
selected, the new line is added above it.
Update
Update the selected condition in the Current SQL Condition list.
Other Controls
Link template list
Select the link template that specifies the table containing the data to use
for this query condition.
This list displays only the link templates available in the source(s) you are
querying. For example, if you are querying source (attached) drawings, the
list will display only the link templates in your source drawings. If you are
querying the current drawing, the list will display only the link templates
in the current drawing.
You can query only one link template in a SQL condition. To query a
different link template, create a new SQL condition.
SQL Link Condition dialog box | 1869