I'm accessing an existing SQL 2005 table that has a TEXT field with length of 2147483647. The data in the field is character-delimited. (If I want to find the Date of Service, I'd have to look for "DATEOFSERVICE" and date would appear shortly after that.)
Is there a way to do this?
Does the TEXT field need to be convert to char? If so, how?