Max Data Type In SQL2000

Anything I can use in SQL2000 in place of varchar(max) (only in SQL2005) with a 2 GB-per-instance capacity



DECLARE jkcursor CURSOR

READ_ONLY

FOR SELECT top 100 episodeid,episodedate,journalentry

FROM ccnidcdw.[Pre-AuthThin].dbo.tbljournal

WHERE journalentry like '%CoCustServ%'

DECLARE @episodeid varchar(15), @episodedate datetime, @journal varchar(2gb)

OPEN jkcursor

FETCH NEXT FROM jkcursor INTO @episodeid,@episodedate,@journal

WHILE (@@fetch_status = 0)

BEGIN

print @journal



FETCH NEXT FROM jkcursor INTO @episodeid,@episodedate,@journal

END

CLOSE jkcursor

DEALLOCATE jkcursor



thanks