Since the nTEXT datatype is depricated in MSSQL 2005 and greater, what would be the ramifications for change the nTEXT database to nvarchar(max)?
I need to do some string manipulation on the Description column for a datafeed, but can't use LTRIM or RTRIM on nTEXT fields. I know I can cast the field, but was trying to not use a bandaid option.
Regards,
David B