Hi,



I found a problem with SELECT . LIKE in FB >= 2.1.

I didn't test again with 2.0.x but I think it was ok with those versions.



The test database is in attach.



I have this field TIPO_DOC CHAR(5);

Select * from test1 where tipo_doc like '%A';

Doesn't work.

There are 5 tables in the database, all with just one field and the same
data.

Table TEST5 has the field created has VarCHAR(5) instead of CHAR(5).

With table TEST5 the query works fine.



The question is shouldn't it work for both char(5) and varchar(5)?



All values in the BD have less than 5 chars.

All field values that end with 'A' have only 2 chars.



Can anyone confirm this?



Thanks.



Luis Madaleno



[Non-text portions of this message have been removed]