[thelist] updating two text fields in MSSQL

[Canfield, Joel]

We have two free-form text fields in a web tool, writing to TEXT fields
in MSSQL (fieldnames DESCRIPT and NOTE.)

I need to make DESCRIPT = DESCRIPT + ' Original Request: ' + NOTE, and
make NOTE = Left(NOTE,256)

Except, it looks like I'd have to use UPDATETEXT or something funky like
that because the + string concatenator doesn't work with TEXT data
types.

Any suggestions?

spinhead