Reading a text field

[Josh]

How do I get the data out of an MS-SQL Text field efficiently

A simple "SELECT [FieldName] FROM

" unfortunately returns a truncated
version of the fields contents ( which actually contains an entire book ).

I know that your not supposed to do a simple select, but my Google-Fu is
weak and I dont know what words to search for.

Can anyone supply some hints?

Thanks

 

[Cor Ligthert[MVP]]

Josh,

As I saw Bill's code, then I assume that this will work as well.

http://www.vb-tips.com/DataSetImage.aspx

(Be aware that you don't need the office offset)

Cor