>>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.