When writing a query, I need to use only the sql-92 standard. Is SUBSTRING(); "clean" sql-92? And is there any detailed directory of what is supported in it?

    2 answers 2

    Yes, SUBSTRING is included in SQL-92 ( see standard , § 4.2.2.1):

      <character substring function> is a triadic function, SUBSTRING, that returns a string extracted from a given string according to a given numeric starting position and a given numeric length. Truncation occurs when the implied starting and ending positions are not both within the given string.

      Here is a link to the text of the SQL-92 standard:

      Sql1992.txt file

      Of course, it’s not very convenient to use, but with the help of contextual search, you can determine if this or that construction of a particular SQL dialect is described in this standard.

      For example, SUBSTRING is in the list of reserved words on the page with the index X3H2-92-154 / DBL CBR-002 and further when describing string functions on the page with the index X3H2-92-154 / DBL CBR-002