I have an old database that still contains depreciated Text fields. I need to pull from these fields and display the results. You would think this should be easy...

First my select statement caused a problem:

Code:
SELECT DISTINCT ..., CustomerInstructions, ... FROM Orders
where CustomerInstructions is a Text field.

The error I get: "The text data type cannot be selected as DISTINCT because it is not comparable." A quick search shows I can cast the text field as a varchar(max).

Code:
SELECT DISTINCT ..., CAST(CustomerInstructions AS VARCHAR(MAX)), ... FROM Orders
Now I get an error while trying to load the instructions into a text box: "Specified argument was out of the range of valid values. Parameter name: index"

Not sure what the problem is here. I have text and a text box. What's with the "out of range" crap?