not displaying data out of recordset

[msimmons]

Originally posted by JoshT
Maybe you could use CAST or CONVERT to change the data to varchar in the SQL query:

SELECT CAST(NumericData AS varchar) FROM Table1

But varchar can only hold 8,000 charicters correct? It is possible that some of the fields will have more than that.
Thanks,
Michael