Hi Gary,

Can you update such column from the Query Analyzer? Does WHERE condition involves that column?

>
>I am trying to update a SQL server VARCHAR(1024) column with an UPDATE ... SET command. In many rows, the column appears blank but after inspecting the value(s), they appears to be CHR(13)'s.
>
>No matter what I do, the columns containing these CHR(13)'s just fail to respond to the SET command (all other rows with normal character data in this column update fine).
>