"witek" wrote:
select * from [DB$] where UPPER(Field) = "UPPERCASE" does not work.

Try:

SELECT * FROM[DB$] WHERE UCASE(Field) = 'UPPERCASE';

Use single quotes from strings and UCASE instead of UPPER.