Retrieving Text Data type(a bit urgent)

[choudary]

I have defined one of the columns of my table as Text datatype where i am storing large amount of text(around 2kb)and while retrieving the data from that field only some part of the data only is getting retrieved.

For this when i referred the Books Online i found an example like this .

USE pubs

GO

DECLARE @ptrval varbinary(16)

SELECT @ptrval = TEXTPTR(pr_info)

FROM pub_info pr INNER JOIN publishers p

ON pr.pub_id = p.pub_id

AND p.pub_name = 'New Moon Books'

READTEXT pub_info.pr_info @ptrval 1 25

GO




but it is also not working fine.

Please help me
Thanks
Choudary


[sig][/sig]

 

[ColinM]

You could try storing it in a varchar.
As varchar can go up to about 8000.

[sig][/sig]