Error In Sql Query

[Mittineague]

@SamA74

It would have been much easier if you stored the values as an integer all relating to one unit or measurement.

That’s what I said

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?