| 
  
           
            Checks
that a given string contains the characters of a second given string
and returns the part of the first string that precedes the occurrence
of the second string.
            
            
             
            
            
             Syntax
                substring-before(string, string) 
            
             
            
            
             Parameters
            
             Two
string values separated by a comma.
             
              substring-before
             
             checks
that the first string contains the second string.
             
            
             
            
            
             Returns
            
             A
string that contains the characters from the first parameter that
precede the occurrence of the second parameter in the first parameter.
If the first parameter does not include the characters from the
second parameter,
             
              substring-before
             
             returns an empty
string.
             
            
             
            
            
             Example
            
             The
following expression returns
             
              2005
             
             :
             substring-before("2005/04/01","/") 
           |  |  |