Home Forums SQL Server 7,2000 T-SQL Problem with the text data column, variable RE: Problem with the text data column, variable

  • September 1, 2008 at 4:34 am

    #865622

    If you are using sql server 2005, then use VARCHAR(MAX) datatype instead of text datatype.

    if you are using sql server 2000, then you have to first split the string to a variable of length less than 8000. Then split the string again for the specified delimiter.