Range for BETWEEN

why is the end limit of the range not included in alphabets but included in numbers, while using BETWEEN operator?

A movie named ‘J’ would be included. But any other name starting with ‘J’ and having some more characters wouldn’t be included because it is greater than ‘J’ and you have queried up to ‘J’. It’s just string comparisons.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.