Contains
The Contains function searches for a substring within a string.
Syntax
"Contains"(<string>, <string>) |
Place the parent string to search in the first parameter. The second parameter is the substring to find in the parent.
Return Type
Boolean
Details
Contains is a reserved word in Connect. Invoke the function by surrounding the function name in double quotes.
The search is case sensitive.
Examples
select first_name, "Contains"(first_name, 'a') from xactly.xc_participant;
Check if items in a delimited list match a valid business group:
set v_biz_group_list = 'EMEA, Americas, bogus1, bogus2'; select name, "Contains"(:v_list, name) from xactly.xc_business_group bg where "Contains"(:v_list, name) = true;
