Posted by Erland Sommarskog on 07/18/07 21:18

rdraider (rdraider@sbcglobal.net) writes:
> Thanks for the info. My problem is the resulting data will be too large
> for varchar(8000). All these examples seem to use varchar(8000)
> I need to convert to a text datatype. I can concat multiple varchar fields
> from 1 record into text but the problem is how the source data is
> structured.
> The source data is from an app called 'Onyx' running SQL 6.5 (I'm naming
> names !!). I upgraded the SQL 6.5 to SQL 2000. I don't hav SQL 2005.

I think you have two options:

1) Get SQL 2005.
2) Do it client-side.

I think you can do it on SQL 2000, but then you would have to run
a cursor, and use WRITETEXT and UPDATETEXT and it would be very very
painful. Please don't ask me to write the code for you, but if you
have problems with using WRITETEXT and UPDATETEXT, I can try to assist.

> I assume it was designed this way because SQL 6.5 largest data type was
> varchar(255) ?

Yes, that is correct.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Establishing Precedence In ORDERBY Condition Causing Problems.
• Prev in forum: db_owners unable to see login list
• Thread view: Re: Combining many records into 1

[Reply to this message]