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 (AT) gmail (DOT) com> wrote in
news:1168561093.951362.110370 (AT) 51g2000cwl (DOT) googlegroups.com:

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

--
felix

Thanks Felix, absolutely perfect.

Peter.


Felix Geerinckx wrote: