I've got a lot of tables that I want to fill with a missing data value when the entity is NULL. I really don't want to do this one column at a time. By using the FCOUNT() function I can get the number of fields, and the FIELD() function I can get the field name. How can I use this to then test if the value of column returned by FIELD() is null, and then fill it with the appropriate missing data value?
thanks
Some days it's not worth chewing through the leather straps ...