HP 3000 Manuals

Using Apostrophes and Quotes [ HP PC API User's Guide for ALLBASE/SQL and IMAGE/SQL ] MPE/iX 5.0 Documentation


HP PC API User's Guide for ALLBASE/SQL and IMAGE/SQL

Using Apostrophes and Quotes 

In ALLBASE/SQL, a single apostrophe or quote characters terminate the
definition of a string variable.  Apostrophe and quote characters may be
included within string variables by using a pair of the desired
apostrophe or quote characters.  The pair is passed to ALLBASE/SQL and is
treated as a single character.  An odd number of these characters is
treated as a pair or group of pairs followed by a string termination.

Therefore, a single apostophe in a name should be doubled.  For example,
the single apostrophe in the name O'Brian should be typed as O''Brian.



MPE/iX 5.0 Documentation