Difference between revisions of "STARTSWITH"

From AgileApps Support Wiki
imported>Evelyn
m
 
imported>Aeric
 
Line 4: Line 4:


  STARTSSWITH('string', 'searchString')
  STARTSSWITH('string', 'searchString')
{{:Common:CaseSensitiveSearchString}}


;Return:TRUE or FALSE
;Return:TRUE or FALSE

Latest revision as of 00:52, 4 June 2014

The STARTSWITH function determines whether a target string starts with (begins with) a search string. This function returns TRUE if the target string starts with the search string. If the target string does not start with (begin with ) the search string, this function returns FALSE.

Syntax
STARTSSWITH('string', 'searchString')

Notepad.png

Note:
The searchString is case-sensitive. For a case-insensitive search,
use the LOWER function on both the search string and the string being searched.

Return
TRUE or FALSE
Examples
STARTSWITH('admin@stop.com', 'admin') = TRUE
STARTSWITH('john@stop.com, 'admin') = FALSE