>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
Elyse Pomerantz