This is a generic problem - I have no control over the data and need to solve the problem by programming without analyzing each application. However, I do have control over the way the data is stored and can use user-defined types.
I guess I could partially restate the problem as: How many varlena columns can be supported in a table with a standard 8K blocksize?
Gerry
__________ Information from ESET NOD32 Antivirus, version of virus signature database 4001 (20090411) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com