Thanks Stefan,

Just what I needed.

// Sven

--- In firebird-support@yahoogroups.com, Stefan Heymann <lists@...> wrote:
>
> Sven,
>
> this page
> http://www.destructor.de/firebird/charsets.htm
> should give you a first introduction to character sets and collations.
> After reading that, you should understand the correlations between
> character sets, collations, and your SELECT statement (if not, bash
> the author ;-)
>
> Best Regards
>
> Stefan
>
>
> > Hi all,
>
> > This might be a simple question for some, but I need to know.
> > When I do a select with like and use swedish characters it does not
> > work right.
> > I use a select statement like:
> > SELECT * FROM TABLE1 WHERE (UPPER(FIELD1) LIKE '%ÖSTRA%');
> > My problem is that if the value is not spelled with a upper case this
> > statement does not work.
> > I suppose I have to change the character set, but wich one should I
> > use and how do I do it?
>
> > best regards
> > Sven
>
>
> --
> Stefan Heymann
> www.destructor.de/firebird
>