Re: Searching for a trim() function
> Chuck Ludwigsen so eloquently writes
>
> Okay, I give up! How can I return a character string without trailing
> spaces in order to concat it with another character string? Mind you,
> I have been able to do this using varchar columns but I've been told
> that varchars cost big on performance. Our tables often exceed 5M rows.
> I am on Informix 5.
>
> (part 1)
create procedure trim(str1 char(25),str2 char(25))
returning varchar(30);
define ret_string varchar(30);
define tmp_str1 varchar(30);
define tmp_str2 varchar(30);
let tmp_str1=str1;
let tmp_str2=str2;
let ret_string=tmp_str1 CLIPPED, " ", tmp_str2;
return ret_string;
end procedure