Using SQL Server, I am preparing the update line in a string and then using that string to update some fields for the record. I am using the single quote to encapsulate the value. However, sometimes, I can have a single quote in the value. So, I decided to do something like this: ... SET FIELD1='First part'+CHR(39)+'second part'...

However, SQL Server does not understand CHR().