>>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().
>SQL use the form: CHAR(integer_expr).

Thanks, that works perfectly.

Also, thank to the others who helped me in this. I could have used the quote quote technique as well.