>>Try...
>>SET NULLDISPLAY TO ""
>>//:^)
>>>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
>
>NULLDISPLAY works for how it appears, but it doesn't change the type of data. I need to string the values of the fields together and come up with a valid character string.
>
>Elyse
How about setting the "Allow Nulls" setting off on the table definition screen for the database. This way you should not get any null values in the tables in the first place.