> My only fear here is that varchar will eat up a lot of memory.  

A little less than NOTE fields, I think, since they are not padded (at least, I
think they're not).

> These are 
> about 8 fields (Columns) in a row.   Also, if the pointers get broken, it 
> is a disaster - these are medical records.  

Personally, I haven't seen that happen.  But you're right, this is probably a
harder problem to fix than corruption limited to the #2 table.
--
Larry

Reply via email to