TEXT_BEFORE Function

Parameters (String, String);

Returns: STRING

Function to return all characters before the first instance of the search string.

The first parameter is the source string.

The second parameter is search string.

If the first parameter is NULL, NULL is returned.

If the second parameter is NULL, the first parameter is returned.

Example: TEXT_BEFORE('Hamburger','b') = ‘ham'

Example: TEXT_BEFORE('Hamburger','i') = 'Hamburger'