Handling Parentheses
SQL Smart has full support of handling parentheses in search values. One demand is that there is as many left- as right parentheses.
Example:
A search should be done for all accounts within the interval 3000-3099 for product 140, or all accounts in the interval 3000-3099 for units between 1400-1499.
Search object | Search value accourding to SQL Smart syntax | Resulting SQL |
|---|---|---|
ACCOUNT | 3000-3099(PROD:140;(UNIT:1400-1499)) | ACCOUNT between '3000' and '3099'and(PROD = '140'or (UNIT between '1400' and '1499')) |