>I am creating 2 local views with the following characteristics:
>
>Table A has cFileno
>Table B has cFileno, cName, cGroup where cGroup can either be "1" or "2"
>
>View 1:
>For each A.cfileno there is at least one or more B.cfileno from cGroup "1".
>With this I create LocalView1
>
>View 2:
>For each A.cfileno there is not always a B.cfileno from cGroup "2"
>
>I need a second local view where all A.cfileno are present including the ones that do not have a B.cfileno from cGroup "2". I can create that view and I obtain B.cfileno = .NULL. for those that are not equal to A.cfileno.
>
>Now instead of the null for those records I want to substitute a fixed (same) value to all of them. (The value is a common cFileno from Table B in cGroup 2) How can I do that?
>
>Thanks in advance
Raymond,
SELECT View2
REPLACE ALL ViewFieldName WITH "FileName" FOR ISNULL(ViewFieldName)