On Sun, 22 Aug 2021, 02:49 Rick Hillegas, <rick.hille...@gmail.com> wrote:

> Hm. I don't think that UPPER operates on numeric data
>
No, I elided the conversion to char: upper(char(X)) or whatever.

And now I understand what you meant. All I want is string data sorted case
insensitively, and numeric data sorted numerically, so changing the
collation will probably be OK. Thanks again.

>
>

Reply via email to