Hi All

is there a way I can store the result of 'readtext' into a variable ?

say for example :

delcare @ptr varbinary
declare @str varchar(1960)
select @ptr = textpr(textcolumn) from texttable

can i do something like : select @str = readtext texttable.textcolumn 0 100 ?

Pls. share your thoughts. thanks.