2072760 - Using Apostrophe in SQL statement returns 7200 error

• Strings that includes apostrophe returns 7200 errors
  i.e.  "Client's Name"
• The following statement returns error:
  i.e. UPDATE <table> SET <field> = 'Client's Name' WHERE <field> = 'CLIENTS NAME';

• SAP Advantage Database Server 11.1
• Sybase Advantage Database Server 10.1

syntax, paramterize, backslash , KBA , BC-SYB-ADS , ADS (Advantage Database Server) , Problem