HP 3000 Manuals

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


HP ALLBASE/SQL PC API User's Guide

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