BUG: Problem with Selecting Text Data into a Local Char or Var (152052)

SYMPTOMS

If a text column has more than 1155 bytes of data, then using UPDATETEXT to delete initial 'x' bytes and then selecting next 'y' bytes using the CONVERT function (of course <= 255 bytes) into a local char or varchar variable would always populate the variable with first 'y' bytes. Note that after running UPDATETEXT to delete data, running READTEXT or a simple select (not populating a variable) shows that the data in the table has been deleted properly. This does not happen when the text column has data up to 1155 bytes.