XML Guide

Back Next

substring-before

Returns the part of a string that occurs before a substring.

substring-before ( string, substring )

The following table describes the arguments for this function:

Argument	Description
string	String datatype. Passes the string to search.
substring	String datatype. Passes the substring to search for in the string.

String.

Empty string if the substring is not found.

NULL if a value passed to the function is NULL.

The following expression returns the number that occurs in a Third Street address:

substring-before ( ADDRESS, Third Street )

The following table contains example attributes and return values: