AA2e72E wrote:
"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.

Thanks.
it works.
I use single quotation. It was my mistake writing post.

There is still a question if there is a way to change compare method to
case nonsenstive instead of unsing upcase function.