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

Probably, assuming you have other field types in your tables. But I'd use the NVL() function istead of an IIF(EVALUATE()).

Regards,