>>>This will work with character fields, but do I have to build in conditional IIF logic for all field types?
>>>
>>>
>>>
>>>SCAN
>>> SELECT iaccts
>>> SCAN
>>> FOR I = 1 TO FCOUNT()
>>> REPLACE (FIELD(I)) WITH IIF(EVALUATE(FIELD(I))='.NULL.','',EVALUATE(FIELD(I)))
>>> NEXT
>>> ENDSCAN
>>>ENDSCAN
>>>
>>
>>See Set NullDisplay in help.
>
>That's cool, but I need to actually replace the values. The index gets confused if there are .NULL. values in the fields contained in the tag.
Ummm. Jay?
Can't you use NVL in the tag expression so it won't get confused or am I confused? :)