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?