I know the foxpro upsize wizard converts the foxpro memo fields in to a text data type in SQL, but is this the best match. I belive that text data fields are only 4000 + characters. Is that correct? My new project has alot of memo fields in the data structure and Iam planning to move it into SQL 2000. What special problems will I have with storing and searching and updating foxpro memo fields and what is the best SQL data type to use. Thank everyone so much ????