Hi,

I have a strange thing in a table of my database.

I select

select nr1, textval
from mytable
where nr2 = 40

The result is OK:

nr1 textval
---------------
17 A


But if I do a selection like

select nr1, textval
from mytable
where nr2 = 40
and lower(textval) = 'a'


The result is emty.

Why?


nr1 is decimal(5), nr2 is decimal(3), textval is char(5)

There are no whitespaces around the text value.

If I select "... and textval = 'A'" the result is OK (The record will
be found).
If I omit the field 'nr1' in the fiellist of the select statement, the
result is also OK.
If I select "... and lower(textval) = lower('A') there is no result.
If I select "... and alpha(textval) = alpha('A') the result is OK.


May it realy depend on the 'decimal(3)' Field?

Does anybody have an idea?
Or has anybody had the same problem?


Thanks

Roland