Hello Lioudmila!
You need to use the following code:
| Code |
|---|
Query = New Query;
Query.Text =
"SELECT
| Addresses.Owner AS Owner,
| Addresses.City AS City,
| Addresses.State AS State,
| Addresses.ZIP AS ZIP,
| Addresses.Owner.Description AS OwnerDescription
|FROM
| Catalog.Addresses AS Addresses
|WHERE
| Addresses.Description LIKE &Description
|
|ORDER BY
| State DESC"
Query.SetParameter(Description, "%Trafik%");
|
Note the "%Trafik%":
if you use the symbol "%" - there can be any sequence of arbitrary characters;
if you use the symbol "_" - here is also any symbol, but only one.
Aleksandr
