I got a temp table that has text field i would to read that text field in my stored proc. I am doing substrings to read the pieces of data from Text field but after 255 i cannot read anymore. Is there way that i can read the text all way to the end piece by piece.
I need to select the content of the text field into variable. But i cannot select the entire text into a single variable because the limit is 255 for variables and we cannot declare text as variable.