SQL Server export varchar(max) column to text by Shiji Pan Posted on March 7, 2012 by Shiji Pan 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!