If you are just displaying this from Query Analyzer, I don't think you'll see your whole TEXT field. However, if you use it in a program, the entire TEXT field should be returned.
BTW ... you don't have to have the "text in row" option enabled. All that does is store the data directly in the row instead of storing a pointer there and the data elsewhere. It doesn't affect anything other than the speed of retrieving the info.
~~Bonnie
>I've created a table in SQL server having a column with TEXT data type,
>The problem I'm facing is I'm unable to get the complete text (more than 254 characters) from select statement
>
>Also I'm unable to get the complete data from my VFP application if I use the SQLEXEC() function ( it is returning a memo type filed in SQLRESULT cursor with only first 254 characters. )
>
>the complete sequence of statement is given below:
>
>
>-- I have created the following table in SQL Server
>CREATE TABLE msg ( msg_id char(10) NOT NULL,
> msg_type numeric(1) NOT NULL,
> msg_date datetime NOT NULL,
> dept_id char(2) NOT NULL,
> msg_desc text NOT NULL,
> last_update datetime NOT NULL,
> TS timestamp )
>GO
>
>-- Now I am enabling the "text in row" option for the above table so that it can store the large text in a row
>sp_tableoption 'msg', 'text in row', '4000'
>GO
>
>-- Now I am updating the table with large text value
>
>UPDATE msg
>SET msg_desc = 'Message From : 06 06 THE PERFECTION HOUSE
>Please send me the details of location in my region so that I can communicate with them for the better relationship. I have already completed the tasks assigned by you and waiting for new assignments.
>
>Also please send me the details of payment of our accounts so that we can reconcile the same in our books.
>
>Thanks
>
>Yours Faithfully,
>
>Raoshan'
>WHERE msg_id = '0600000016'
>GO
>
>-- Now I'm trying to get the same from the following statement
>SELECT msg_desc FROM msg WHERE msg_id = '0600000016'
>GO
>
>-- It is showing only first 254 characters of data and the other data is missing.
>
>>
>Please help me out
>
>Thanks
>
>Raoshan
