UPPER & LOWER don't work in UDF

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.

"pandpp" <tipping.homeschool@gmail.com> wrote in
news:1168561093.951362.110370@51g2000cwl.googlegro ups.com:

> 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.

http://bugs.mysql.com/bug.php?id=12903

--
felix

Thanks Felix, absolutely perfect.

Peter.


Felix Geerinckx wrote:
> "pandpp" <tipping.homeschool@gmail.com> wrote in
> news:1168561093.951362.110370@51g2000cwl.googlegro ups.com:
>
> > 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.
>
> http://bugs.mysql.com/bug.php?id=12903
>
> --
> felix