Skip to main content

This is documentation for Caché and Ensemble. See the InterSystems IRIS version of this content.Opens in a new tab

Please read this important announcement about the future of Caché and Ensemble maintenanceOpens in a new tab. Contact your account team to migrate to InterSystems IRIS.

SQL MultiValue Support Functions

  • $MVFMT – A MultiValue formatting function for a string.
  • $MVFMTS – A MultiValue formatting function for dynamic array elements.
  • $MVICONV – A MultiValue external-to-internal conversion function.
  • $MVICONVS – A MultiValue external-to-internal conversion function for dynamic arrays.
  • $MVOCONV – A MultiValue internal-to-external conversion function.
  • $MVOCONVS – A MultiValue internal-to-external conversion function for dynamic arrays.
  • %MVR – A MultiValue collation sequence function.
SQL Unary OperatorsNext section
Previous sectionSQL Functions
FeedbackOpens in a new tab