First, you need 
SqLobEditor and install it.
Run SqlLobEditor, 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
