Stefan Wild wrote on 15.08.2010 10:36:
>> column is numeric, but upper() works on text, and returns
>> text, so your
>> numeric column got casted to text by using upper (which is
>> pointless
>> anyway - there is no "upper" version of digits).
>> remove upper() and you'll be fine.
>>
> Thank you guys! That was the point.
The real question is:
what did you try to accomplish with the UPPER() on a numeric column?
Regards
Thomas