Re: Capitalize each word in a string ?

[Deepika Gupta]

I also had the same requirement some time back and this is the function I ended up with. Any comments.

create function uppercase(str varchar(255)) returns varchar(255)
return concat(upper(left(str,1)),lower(right(str,length(str)-1)))

create function initCaps(str varchar(255)) returns varchar(255)
begin
declare pos int;
set str = uppercase(str);
set pos = locate(' ',str);
if pos = 0 then
return str;
else
while pos != 0
do
set str = concat( substring(str,1,pos),upper(substring(str,pos+1,1)),substring(str,pos+2,length(str)) );
set pos = locate(' ',str,pos+1);
end while;
end if;
return str;
end;