Subject Re: [firebird-support] between operator on a varchar field
Author Svein Erling Tysvær
CHAR, VARCHAR etc. are sorted alphabetically, and (at least in most countries, don't know about languages written from right to left) that means that you first compare the first character, if that is equal the second, then the third and so on until there is a difference. E.g. 'three' < 'two' since 'h' < 'w'. C BETWEEN A AND B is just a different way of writing C >= A AND C <= B.

So, if you want 2015 to sort before 2017, then you have to have the year before the characters, e.g.

’2017/AHH00091’ and ’2017/AHH00141