WebSphere Message Broker, Version 8.0.0.7
Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS
See information about the latest product version
See information about the latest product version
STARTSWITH function
STARTSWITH is a string manipulation function that manipulates all string data types (BIT, BLOB, and CHARACTER), and returns a Boolean value to indicate whether one string begins with another.
STARTSWITH returns TRUE if SourceExpression begins with SearchExpression, otherwise it returns FALSE.
The parameter strings for both SearchExpression and SourceExpression can be of the CHARACTER, BLOB, or BIT data type, but must be of the same data type.
If any parameter is NULL, the result is NULL.
Examples
STARTSWITH('Hello World!', 'Hello');
returns
TRUE. STARTSWITH('Hello World!', 'World');
returns
FALSE.