If you use
SELECT * on a table with the column type
NTEXT, your resultset will not display the
NTEXT column on a Web page when using ASP to show the recordset.
To ensure that the NTEXT contents display, move the NTEXT column to the last column in your recordset. If you are pulling data from a view, the same thing appliestry thinking of NTEXT columns as the 'anchor' to your recordset.