>Is there a memo field in SQL Server like there is in Visual Foxpro? Or what is the equivalent of a Visual Foxpro memo field in SQL Server?

The text data type is equivalent of VFP memo. For small sizes you can use varchar but it's size is limited to 8000 bytes or whatever room left in the record ( max length 8060 bytes) after other columns.