Su, Xiaomeng 76a5b1ee83 dli_sqlreference_20240227

Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Su, Xiaomeng <suxiaomeng1@huawei.com>
Co-committed-by: Su, Xiaomeng <suxiaomeng1@huawei.com>

2024-03-27 22:02:33 +00:00

4.7 KiB

Raw Permalink Blame History

char_matchcount

This parameter is used to return the number of characters in str1 that appear in str2.

Syntax

char_matchcount(string <str1>, string <str2>)

Parameters

**Table 1** Parameter
Parameter	Mandatory	Type	Description
str1, str2	Yes	STRING	str1 and str2 to be calculated

Return Values

The return value is of the BIGINT type.

If the value of str1 or str2 is NULL, NULL is returned.

Example Code

The value 3 is returned.

select char_matchcount('abcz','abcde');

The value NULL is returned.

select char_matchcount(null,'abcde');

Parent topic: String Functions

4.7 KiB Raw Permalink Blame History