Subject Re: How to specify which UPPER() to be called
Author peter_jacobi.rm
Hi Svein,

--- In, Svein Erling Tysvaer wrote:
> Maybe it is, but I do find your test very strange. Whenever I want to
> compare the uppercase equivalent of a field with a constant, then I
do make
> sure my constant is in uppercase to start with.
> [...]

Of course the example looks like a lesson insilliness on
its own. But it's only test for a situation where the
string to look for is entered by the end user in a GUI.

On the other hand, even when entering the query myself on
the console, I may want to make Firebird to the uppercasing
on both sides of the equal sign, to be sure no disagrement
about the correct uppercasing occurs. For example, in a another
locale 'Füße' may have been uppercased to 'FÜSSE' or even

Peter Jacobi