Hi, i have a problem to generate variable containing white character
string. Ex if my variable P_SIZE has 8 for value, i need to have in the
V_ZONE variable ' ' but now i receive '' . What i do wrong or
how can i solve my problem?

Thanks

Here's my proc:

P_SIZE INTEGER;
declare variable V_LG Integer;
declare variable V_ZONE Varchar(2000);

V_ZONE = '';
V_LG = 1 ;
WHILE (V_LG <= :P_SIZE) DO BEGIN
V_ZONE = V_ZONE || ' ' ;
V_LG = V_LG + 1;
END