>That's been my understanding, that the change to varchar(max) works well. Like I said, the only potential "gotcha" is if some client application actually/explicitly looked for the older data type.
This is a controlled environment.
>That MAX keyword has saved my life many times. I've had situations where I've had to build very large SQL queries to pass into linked servers for DB2 and Oracle.
And, there's that. Thanks