It is very nice to have a concise overview of text functions and handling. Well done!

There is a serious concideration with regards to triggers, however, since Text columns cannot be included.

an error "Cannot use text, ntext, or image columns in the 'inserted' and 'deleted' tables." will occur.

If anybody has ideas for Archival functions using Triggers, let me know.

Cheers,

John R. Hanson