Hello again,



our ERP-Partner need all strings in a transfertable (firebird 2.5) filled
with blank characters. Example: 'article 123' filled to the length of 20:
'article 123 '. Now I have created a little procedure:



CREATE PROCEDURE U_VC_TO_A (

VC_IN VARCHAR (40),

STELLEN INTEGER)

RETURNS (

A_OUT VARCHAR (40))

AS

BEGIN

a_out = u_pright(vc_in,' ',stellen);

insert into tmp(c40) values (:a_out); --test!

SUSPEND;

END



U_pright is a function from freeudf (u_padright). It works (test it with
adding a new string on the blank character filled), but how can I save blank
characters in the firebird-table? I have test it with char and
varchar-fields, but the blank characters were missing (EMS-IB-Manager)



Thank you very much.



Olaf.



[Non-text portions of this message have been removed]