In the example given for the BETWEEN operator, why are all records A up to but not including J returned. Yet with the year example all records 1990 and including 2000 returned? The two queries look to be written the same. Why with names are J not included but with year 2000 is included?
All the documentation I could find says BETWEEN is inclusive of both lower and upper value, but the proof is in the pudding, for text, the upper value is exclusive. Wish I could find some explanation for this, but so far, none. Will need to do more digging. If you find a definitive answer, do please share it with us.
It doesn’t make sense, though. How does one get up to Z?