Hello,

I had a pretty decent Google for this, so apologies if this has been
answered many times before.

I am trying to make a UDF to change case.

What troubles me though is that I can't seem to get either LOWER or
UPPER to change the case, when it's called inside a UDF.

If the UPPER or LOWER is called outside, it works brilliantly, as
expected.

I got desperate in the end & took the doco example, as detailed below:
CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50)
RETURN CONCAT('Hello, ', UPPER(s), '!');

When I call this function as detailed in the doco (SELECT
hello('world')), I would expect:
Hello, WORLD!

I don't, I get plain old:
Hello, world!

I'm running MySQL 5.0.17 through Uniform Server.

I've tried everything I can think of, so be interested in what
suggestions people have to offer.

Thanks,
Peter.