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