The COUNT function counts the number of elements in a set.
The COUNT function has the following format:
COUNT(set[, case_sensitive])
The COUNT function accepts the following parameters:
set (string)
Specifies a string of elements that are separated by the caret character: 'element1^element2'. Each element is a string.
case_sensitive (Boolean)
(Optional) Specifies case sensitivity.
The COUNT function returns a number.
Return_value=COUNT('phoebe^PHOEBE^robin^robin')
Return_value=4
Return_value=COUNT('phoebe^PHOEBE^robin^robin', FALSE)
Return_value=2
Return_value=COUNT('phoebe^PHOEBE^robin^robin', TRUE)
Return_value=3
Copyright © 2010 CA. All rights reserved. | Email CA about this topic |