Decomposition of strings in SQLScript


Mit dem Laden des Videos akzeptieren Sie die Datenschutzerklärung von Vimeo.
Mehr erfahren

Video laden

With the functions

  • LEFT(<character string>,<length> ),
  • RIGHT(<character string>,<length>) and
  • SUBSTRING(<character string>,<start position>,<length> )

strings can be split by position and length. And with the functions

  • SUBSTR_BEFORE(<character string>, <pattern>)
  • SUBSTR_AFTER(<character string>, <pattern>)
  • SUBSTR_REGEXPR( <pattern> IN <character string> )

strings are split based on their content. The last function is discussed again in the next topic, which deals with SQL functions for regular expressions.

Pages 172-173 in the book