Exception (NOT)
The Exception (NOT) function can be used to specify conditions with exceptions. For example, if you want to search an interval of accounts with the exception of some accounts, use this function by stating a exclamation mark ! for the exception.
Example:
Search all accounts in the interval 3000-3099, but not accounts 3050 and 3051.
Search object | Search value accourding to SQL Smart syntax | Resulting SQL |
|---|---|---|
ACCOUNT | 3000..3099!3050#3051 | ACCOUNT between '3000' and '3099' and not ACCOUNT in('3050','3051') |