That works, but only if my stored proc contains the suspend.

 

SET TERM ^ ;

 

CREATE OR ALTER PROCEDURE INITIAL_CAPS_PROC (

    input_string varchar(100))

returns (

    output_string varchar(100))

as

declare variable input_length integer;

declare variable idx integer;

begin

  output_string = '';

  input_length = char_length(input_string);

 

  if (input_length > 0) then

  begin

 

    idx = 1;

    while (idx <= input_length) do

    begin

      if (idx = 1) then

        output_string = upper( substring( input_string from 1 for 1 ) );

      else

      begin

        if ( substring( input_string from idx-1 for 1 ) = ' ' ) then

          output_string = output_string || upper( substring( input_string from idx for 1 ) );

        else

          output_string = output_string || lower( substring( input_string from idx for 1 ) );

      end

 

      idx = idx + 1;

    end

  end

 

  suspend;

end^

 

SET TERM ; ^