Hi Ricardo,

>If i understood correctly, you want to change null values by empty values, isn' it? If so, You can use NVL funtion. This funtion returns a non-null value, between 2 variables.
>Example:
>
>a = .null.
>b = "my value"
>WAIT WINDOW NVL(a,b)

>This will return "MY VALUE", because A was a null value, and B wans't.
>You can include NVL at your SELECT statement.
>
>Hope it helps. Nice to hear from you.

Thanks for this info. My only problem that I used (actually, not I, but my collegue) * to select from tables. NVL function requeres each field to be specified, right?
So, as I understand, instead of
SELECT Table1.*, Table2.*, Table3.*, etc.
I need Select NVL(Table1.NumericField,0), NVL(Table1.CharacterField,''), NVL(Table1.DateField,{}), etc., right?

And probably I also need to include as clause also... Too combersome...

The second question is how NVL influences on speed of Query?

BTW, Nice to hear from you too :)