>Hi All, is there a preferred field type I should use for Foxpro "memo" types ?
It depends how many chars you could store in that memo. If you store not more that 8000 chars in that MEMO you could use varchar, (or nvarchar, but it is limited to 4000 chars). In SQL 2005 you could use varchar(max) which allows you to store up to 2^31-1 bytes. I prefer varchar data type to textone, because it is easy to manage and all function works with it whereas some functions (LEFT(), RIGHT(), LEN() ...) doesn't work on TEXT type.