That is untrue. 'A' sorts before 'a' in BINARY. 'A' sorts equal 'a' in NOCASE. Mutatis mutandis all the single-byte latin alphabetic characters [A-Z] and [a-z]. While it is technically true that `'a' collate nocase between 'A' and 'B'` is indeed true, so is `'A' collate nocase between 'a' and 'b'`. For further clarity and to avoid boundary conditions (because I am sure that someone somewhere will claim that 'oh, thats because they are equal') it should be noted that both of the following are also true: `'M' collate nocase between 'a' and 'z'` `'m' collate nocase between 'A' and 'Z'`