Helen,

The issue of variables and NULLs needs some clarification. I have observed
the following behaviour (using IB6):

1- A SELECT INTO statement that retrieves 0 rows does not modify the
involved variables which keep their old values.
2- A FOR SELECT INTO will assign NULLS to the involved variables in a
specific iteration if their corresponding columns are nulls.
3- A FOR SELECT INTO that iterates 0 times does not modify the involved
variables which keep their old values.
4- VARIABLE=NULL is a valid statement.
5- IF (VARIABLE IS NULL) tests if a variable is null or not.
6- A comparison expression involving one operator where one operand is null
evaluates always to false.

According to the above, you do not need to involve v_data_consegna_seggio =
'Something ridiculous'; a simple IS NULL test should suffice.

Please correct me if I am wrong.

Regards



_________________________________________________________
Do You Yahoo!?
Get your free @... address at http://mail.yahoo.com