Hello,
I'm trying to get data out if an image field that was text. I can get the binary information then manually use the convert line to get the text...

Here is what I have:
CREATE PROCEDURE GetChunkData
@bodyID uniqueidentifier,
@chunkindex int,
@chunksize int
AS
BEGIN
-- Find and retrieve chunk data from chunk table
-- returns the first 256 bytes of the field
DECLARE @val binary(16)

SELECT @val = TEXTPTR(chunkdata) FROM relaystorebodychunks where bodyid = @bodyID order by chunkid

READTEXT relaystorebodychunks.chunkdata @val @chunkindex @chunksize

--SELECT CONVERT(varchar(8000), !!covert the READTEXT line!!)

END
GO