PS. My organization previously bought the source code to the COTS package that we have and we are able to manipulate the back-end. My thought is to try changing the field we are concerned about from nvarchar to ntext.
Does that seem like a reasonable thing to try?
Thanks,
Tom