SAP Knowledge Base Article - Preview

2072760 - Using Apostrophe in SQL statement returns 7200 error

Symptom

  • 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';

Read more...

Environment

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

Product

SAP Advantage Database Server 11.1 ; Sybase Advantage Database Server 10.1

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.