Hay everybody and thanks in advanced for any help.
I have a table under MSSQL 2005 Express edition with a text column where I store a well formatted XML document without any XML declarations.
Under VFP 9.0 opening the table trough a VFP view the text column return it value correctly, but when I select it from a program, using the object connection return Null value.

The select statement is like the following, were KMData is the text column:

select *
from appEnv
where bclass=100
and flags='A'
and (kmdata like '%%poeta%%'
and kmdata like '%%fabio%%')

the VFP code is:

LOCAL oRS as ADODB.Recordset,oCN as ADODB.Connection
.
oCN = aApp.conObj && Get connection from a specific method.
.
cSQL = "...." && the SQL statement

oRS = oCN.Execute(cSQL)