SQL Server export varchar(max) column to text

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!