Hello Sven,

p> I use a select statement like:
p> SELECT * FROM TABLE1 WHERE (UPPER(FIELD1) LIKE '%ÖSTRA%');
p> My problem is that if the value is not spelled with a upper case this
p> statement does not work.
LIKE is case-sensitive. Use CONTAINING - that's case-insensitive.

p> I suppose I have to change the character set, but wich one should I
p> use and how do I do it?
Name you current character set and collation. But if your query above
works, then most probably you have right (or at least appropriate)
character set and collation, because otherwise UPPER(FIELD1) wouldn't
upper-case Swedish-specific characters and LIKE would return false for
such data.


--
Best regards,
Pavel Menshchikov
http://www.ls-software.com