<< UPDATE ptsoap SET subj = (subj + .vadjdesc2 + 'xxxxxxxxxxxxxxx 33333333333 ') WHERE custnum = 4545 and ptspid = 4701 >>
I'm guessing that the intermediate value you're calculating in the expression is being incorrectly typed as NOTE. Try SET VAR vSubj VARCHAR = NULL SELECT Subj INTO vSubj FROM PTSoap WHERE CustNum = 4545 AND PTSPID = 4701 SET VAR vSubj = (.vSubj + .vAdjDesc2 + 'Text Here') UPDATE PTSoad SET Subj = .vSubj WHERE CustNum = 4545 AND PTSPID = 4701 Make sure NOT to put parens around the variable name in the UPDATE statement. Does this help? If not, is the error generated on line 3 or line 4 of the code? -- Larry
