I think the web app changed my sql statement

if looks the same it should be replacing "& lt;" to "<" and "& gt:' to "<", no space between &...

No, it would not work because it inside the root. This XML has to be outside the root.

Actually the previous idea was good. I could make it to work perfectly....

Its' a select statement directly from table with fields

Select doc.col1, doc.col2, doc.col3

from TestTable as doc

for xml path ('doc')

the result is one XML column or you can say it's one column,...

does anyone has experience to handle multi languages in a single column for FTS? If so, how to do that? I knew exactly there are 2 languages in the column...

SQL 2008 R2. I am using FREETEXTTABLE

Thanks. I read that but sounds like each column can have one specific language. My question was can ONE column stores multi lingual (English&French) for FTS? Because I can't get...