Hi Elyse!
select *, iif(isnull(yourstr),'',yourstr)
from ....
into ffff
>Is there any way to prevent NULL values in a local view? I need the
>character fields to have empty strings if they are empty.
>
>Thanks
>Elyse
* Human is a question asked by birth and answered by death. Machine is another kind of question with another kind of answer