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