I don't see where in your code you get NULL. Can you elaborate?
Try to running following code and see if text data is presented in the cursor as memo field.

...
oRS = oCN.Execute(cSQL)
oCA=CREATEOBJECT("CursorAdapter")
oCA.DataSourceType="ADO"
oCA.CursorFill(,,,toRS)
oCA.CursorDetach()
BROWSE LAST NOWAIT

>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 '%<fullName>%poeta%</fullName>%'
>and kmdata like '%<fullName>%fabio%</fullName>%')
>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)