>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).
Bob Tracy
Never engage in a battle of wits if you're only half armed.
