Thank you all, yes I ran upgrade advisor and there were no issue, other than sql server level warning

I tried datalength, I tried many other things didn’t work. At this time changing data type not an option. I will run DBCC checkdb

BTW: I added a indexed column on the select and same issue, I don't have any issue on other columns on same table when I do select, only with TEXT column, strange works just fine on sql 2000 on very old computer. maybe sp cache something to do it

Thank you all for your time, I appreciate your inputs