MicroStrategy ONE

LastPosition (Last Position of Substring)

The LastPosition function returns the starting position of the last occurrence of a series of characters in the input string. For example, using the LastPosition function to search for the string "Strategy" within the string "MicroStrategy Inc. MicroStrategy" would return the value of 25.

To find the first occurrence of a series of characters in a string, see Position (Position of Substring).

Syntax

LastPosition (Argument1, Argument2)

Where:

  • Argument1 is the string in which to search for Argument2.
  • Argument2 is the substring to search for.

For information on the syntax used in your specific database, see MicroStrategy and Database Support for Functions and see the section that corresponds to your database.