BETWEEN OPERATOR for VARCHAR data type

Because the binary value for the string "“1TB” is between that for “1GB” and “500GB”

If you want to deal with them as numeric data types best not to use string data type.

Maybe try numeric byte values instead?

2 Likes