Interval (BETWEEN)
This function is used when you want to find an interval of values. You specify this by using the hyphen sign between the from and to value.
Example:
Search for ACCOUNT interval 3500 to 3599.
Search object | Search value accourding to SQL Smart syntax | Resulting SQL |
|---|---|---|
ACCOUNT | 3500..3599 | ACCOUNT between'3500' and '3599' |
ACCOUNT | 3500-3599 | ACCOUNT between '3500' and '3599' |