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