It’s not as easy as you think. Later, I have discussed it with Sundoro and he didn’t find the solution. So I traced it hard to google and BOL, and luckily I found it
. Actually the problem is if you’d like to concatenate the string which data type is text. For example:
update syinvtsearch
set searchStr = searchStr + @Parm_1
where invtID = @Parm_InvtID
It’s simple isn’t it? But for varchar data type, it is not a problem. Have you try it?
