You would need to filter this in the WHERE clause of the UPDATE statement.
set <companycolumn> = REPLACE(<companycolumn>, 'Co', 'Co.')
where <companycolumn> ...
Depending on the nature of the replace, your WHERE clause could vary. If
'Co' would always be the last characters in the column, then the WHERE
clause could be : WHERE RIGHT(RTRIM(<companycolumn>),2) = 'Co'
"Nicolas Verhaeghe" <nospam_nicver_nospam> wrote in message
> I would like to replace the word "Co" in Company field with "Co."
> How do I make sure that the other "co" strings will not be replaced by