You can use SET NULLDISPLAY TO command to specify the text displayed for null values.
>When using SQL code to populate a cursor, the BROWSE window is often filled with the .NULL. descriptor. While I understand the difference between a NULL field and a ZERO or BLANK data type, my preference for the BROWSE window is to show a "0" in anytime a numeric field is ZERO, NULL or BLANK. Playing around with IIF(ISNULL(condition_A),0,condtion_A), I've been able to get the BROWSE/CURSOR to show ZERO's but this is very tedious and makes the SQL statement hard to ready. Is there a simple way to just instruct FoxPro to display a ZERO anytime a numeric value is .NULL. or BLANK?
--sb--