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' |