(Urgent) How Get a Text Field and put the result into a text Var

Hi All

Iam trying to Get a text field value i wrote this code

DECLARE @.ptrval varbinary(16)
DECLARE @.length bigint
SELECT @.ptrval = TEXTPTR(Template), @.length = LEN(Template)
FROM #TEMPLATE
READTEXT Template.#TEMPLATE @.ptrval 0 @.length

but i need to put the result into a text var
is that possible or not and if it possible any one could help me with thatYou could return a text column as part of a result set. Are you trying to get the text back to ASP.NET?