Character arguments

Character arguments in sybase mode must be delimited in one of these ways:

• The value can be enclosed in single or double quotes.

• The value can be enclosed in one of the following special delimiters (passthrough or tsql0 modes only):

  • !

  • %

  • (

  • )

  • *

  • /

  • :

  • <

  • >

  • ?

  • \

  • |

  • ‘

  • {

  • }

  • ~

• The same character must be used before and after the value.

You can specify NULL values in sybase mode in either of these ways:

• With either “NULL” or “null” used as the value

• With the argument left out of the list (if the procedure contains more than one argument)