My app will connect to either a VFP database or a SQL server (switchable by changing an INI file). I have set the TEXT field in SQL, mapping to a MEMO field in VFP, "not nullable" and default to an empty string. I think this is a better choice over setting the TEXT field nullable and default to NULL since code for both VFP and SQL backend will be easier to be kept the same.

What I understand is a TEXT field is a pointer to actual information. May question is will defaulting a TEXT field to an empty string (real value) take up more space than defaulting it to Null (no value).

TIA