>Hello All,
>
>I have a SQL statement with two selects UNIONed together. Both halfs use outer joins.
>
>In the first half, "MyField" gets ALL numeric values as it should. In the scond half, however, "MyField" must somtimes (correctly) get .null. values. Problem? The first half of the union seems to be setting up "MyField" as a "NOT NULL" field and when the second half tries to add null values, I get an error that "MyField does not accept null values."
>
>How can I tell "MyField" to accept NULL values in the first half of the union?
>
>(BTW - reversing the selects won't work because another field - "Myfield2" works just opposite,)
>
>TIA!
>Ken

try select (Myfield + 0) as "MyField"