Compound Conditions (AND)

Related Information

Syntax for SQL Smart

Function:

You can search for several items in a search value by using parentheses as demarcation between the different items.

Example:

Search all accounts in the range 3000-3099 for units 100 and 125.

Search object	Search value accourding to SQL Smart syntax	Resulting SQL
ACCOUNT	3000..3099(UNIT:100#125)	ACCOUNT between '3000' and '3099' and  UNIT in('100','125')