Tracy,
If it's SQL 2000, then you have a text field, but if it's SQL 2005, you should be using varchar(max) instead. Text is going away and varchar(max) is the replacement for MS SQL Server.
HTH,
Chad
>Update: Just noticed you created your cursor as a varchar type. We need to append to the end of a text data type field in sql server 2000/2005.
_________________________________
There are 2 types of people in the world: