|Subject||Re: How to specify which UPPER() to be called|
--- In firstname.lastname@example.org, 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
> 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