I am using a VARCHAR(MAX) parameter in one of the stored procedures. Recently i discovered it might get bigger than 8000 characters. So i changed that parameter to TEXT. But problem is i cannot use RTRIM, LTRIM functions on TEXT datatype. Is there any work around for this problem?