thanks Dimitry. It worked!

--- In firebird-support@yahoogroups.com, "Dimitry Sibiryakov"
<SD@t...> wrote:

> On 11 Aug 2004 at 10:24, tilemahosmanolatos wrote:
>
> >Now what remains is to resolve the following issues:
> >(1) How can I upper a string literal? eg select upper('my greeks
> >here') from rdb$database
>
> Try select upper('Your greek here' COLLATE PXW_GREEK) ....
>
> SY, Dimitry Sibiryakov.