1) SUBSTRING function doesn't work with the TEXT datatype;
2)only PATINDEX and DATALENGTH support the TEXT datatype;
3)Text variables can't be declared, but they're valid as parameters for stored procedures;
4) to read text column READTEXT you have to use chunks of 200 ( in the loop ) until the entire text column has been read ; you also have to use TEXTPTR ( text pointer ) to read text ;


mne prishloc" stolkny"cia c text type - moi covet gde tol:ko moshno icpolzyite varchar(8000) vmesto TEXT