Does anyone know if it is possible to retrieve data from a text field in the same select statement with other fields? For example - I have a text field that cannot be retrieved with a simple select statement due to size. The following obviously does not work. Does anyone know if/how I can do this?
declare @ptrtext varbinary
select @ptrtext = TEXTPTR(my_notes) from my_table where my_id between 1 and 5
select my_id,
my_name,
READTEXT @ptrtext my_table.my_notes 0 18000
from my_table
where my_id between 1 and 5
declare @ptrtext varbinary
select @ptrtext = TEXTPTR(my_notes) from my_table where my_id between 1 and 5
select my_id,
my_name,
READTEXT @ptrtext my_table.my_notes 0 18000
from my_table
where my_id between 1 and 5