SubString Function

Description:
Test if a sub-text occurs, case-sensitive, within a text.
Returns:
Boolean
Parameters:
Parameter
Data Type
Description
1
Text
The sub-text.
2
Text
The text.
Examples:
Expression
Result
SubString( "bcd", "abcde" )
true
SubString( "BCD", "abcde" )
false
note
Local Lookup tables in Contract Express are case-sensitive, therefore Select statements with the SubString function in the “where” part will only return the results with the matching case.
However, this may not always be the case when similar search is run against an external table.
The case-sensitivity of external tables is controlled by the external table resource manager. Typically, SQL servers are set up with a collation which is case insensitive.

Related Content