> I have an uppercase version of a field for case-insensitive
> searching.
> The problem is non-english characters like øæå, they don't get
> converted to ØÆÅ. Is a UDF the only way to do this, and if so, has
> any smart person already made a nice ANSIUPPER udf?

What character set and collation are you using?


Regards,
Thomas