<< I have done some testing and find that once converted, you cannot convert back to NOTE from VARCHAR. Is the VARCHAR field going to take up a lot more space? Also, can I do a search on text in the VARCHAR field? >> VARCHAR is what you're looking for. You can search on VARCHAR just like TEXT or NOTE. It takes about only the room the field needs, and the data is held in the RB4 file, so it doesn't count against the two-gig limit on the RB2 file (you just pay four bytes per VARCHAR for a pointer into the RB4 file). Make sure you're using the most recent version of R:Base (or one even more recent than the most recent -- eg, the one from next Monday) because true TEXT-like support for VARCHAR has been introduced in phases. Not all the string functions will accept VARCHAR yet. -- Larry
