SQL Anywhere® Server - Database Administration  > Database Options  > Introduction to database options  > Alphabetical list of options

percent_as_comment option [compatibility]

Controls the interpretation of the percent character.

On, Off

On

It is recommended that you do not use % as a comment marker.

Versions of this product before Version 6 treated the percent character (%) in SQL statements exclusively as a comment delimiter. Since Version 5, alternative comment markers such as //, /* */, and -- (double hyphen) have been available. The double hyphen style is the SQL/2003 comment delimiter.

Adaptive Server Enterprise treats % as a modulo operator and does not support the SQL Anywhere mod function. Writing a statement that works in both environments and performs a modulo operation was previously impossible.

The percent_as_comment option controls the meaning of %. The default setting is On for backward compatibility. You can set the option to Off for compatibility with Adaptive Server Enterprise.

Procedures, triggers and views that were created with %-style comments are converted to double-dash comments when they are stored in the catalog.