Have a stored procedure that generates HTML order confirmation in a @Email varchar(8000) variable. The problem is periodically the email exceeds 8000 character. We can not define a local variable with type Text. Any suggestion how we can get around this issue? The @Email variable is passed to a Extended Procedure to be processed.