First, you need Download DBBlobEditor 
Run DBBlobEditor, click the “Export LOB” button.
Choose the table name, varchar(max) column name (Lob Field), “Save To”, etc. 
Click “Export” button.
Done!
SQL Server export varchar(max) column to text
by Shiji Pan
