[thelist] updating two text fields in MSSQL

Canfield, Joel JCanfield at PacAdvantage.org
Mon Mar 13 14:02:02 CST 2006

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

Any suggestions?


More information about the thelist mailing list