Is there any way to update/insert data into tables that contain a text dayatype column without the hassles of UPDATETEXT? I would prefer to use standard SQL syntax.

-- Anonymous, October 16, 2001

Answers

Eric,

I don't think so. An alternative is the split the value into multiple varchar values and store these in a separate table, kind of like an array. In this case, the table would contain ID (FK to primary table), LineNumber, TextValue columns.

Hope this helps,

Eric

-- Anonymous, October 23, 2001