>>>I have a view that was created with left outer join. As a result that cursor contains NULL values.
>>>
>>>Now I want to index that view to use in a grid in a form. The problem is that I can't create the index with NULL.
>>>
>>>How can I solve this problem?
>>
>>Forget about that I found what was needed.
>
>NVL function, I guess :) BTW, I had a similar thread about two months ago.
No I used IsNull().
*******************************************************
Save a tree, eat a beaver.
Denis Chassé