>However, we recently got feedback from an experienced SQL-Server DBA at a client who wants us to upsize to SQL-Server that this is a bad design choice because the TEXT datatype is subject to the same type of data corruption that we occasionally see in VFP's MEMO fields.

---

Shawn,

I've been using TEXT datatype for over a year now, and I can't recall any corruption (then again, I can't recall any VFP memo corruption in the last 6 years), so I don't have a problem with TEXT fields.

I have the feeling (and it's only a feeling) that ADOers don't like TEXT because from what I can tell, they aren't as easy to work with than they are in VFP. In ADO, you have to use the GetChunk() method multiple times to get all your data, depending on size, where as in VFP, it just gets converted into a memo field that you can access completly and easily.

Should I be wrong on that one, anyone should feel free to correct me! :)