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