# ListValueCountNoCase

Returns the number of instances of a specified value in a list. The underlying search that finds the instances is not case-sensitive.

See also ListValueCount.

### Syntax

    ListValueCountNoCase(list, value [, delimiters ])

##### list

A list or the name of a list that is to be searched.

##### value

The string or number that the function is to find and count.

##### delimiter

Optional. Specify the character(s) used to delimit elements in the list. The default is a comma ( , ).

### Example

    <!--- This example uses ListValueCountNoCase to see how many
          employees are in a department --->
    <HTML>
    <HEAD>
    <TITLE>ListValueCountNoCase Example</TITLE>
    </HEAD>

    <body  bgcolor="#FFFFD5">

    <CFQUERY NAME="SearchByDepartment" DATASOURCE="cfsnippets">
    SELECT     Department
    FROM     Employees
    </CFQUERY>

    <H3>ListValueCountNoCase Example</H3>
    <P>This example uses ListValueCountNoCase to see how many employees
    are in a department.

    <FORM ACTION="listvaluecountnocase.cfm" METHOD="POST">
    <P>Select a department:</P>
        <select NAME="departmentName">
                <option VALUE="Accounting">
                    Accounting
                </OPTION>
                <option VALUE="Administration">
                    Administration
                </OPTION>
                <option VALUE="Engineering">
                    Engineering
                </OPTION>
                <option VALUE="Sales">
                    Sales
                </OPTION>
        </select>
        </select>
    <INPUT TYPE="Submit" NAME="Submit" VALUE="Search Employee List">
    </FORM>
    <!--- wait to have a string for searching defined --->
    <CFIF IsDefined("FORM.Submit") and IsDefined("FORM.departmentName")>
        <CFSET myList = ValueList(SearchByDepartment.Department)>
        <CFSET numberInDepartment = ListValueCountNoCase(myList,
    FORM.departmentName)>

        <CFIF numberInDepartment is 0>
            <H3>There are no employees in <CFOUTPUT>#FORM.departmentName#</
    CFOUTPUT></H3>
        <CFELSEIf numberInDepartment is 1>
            <CFOUTPUT>
            <P>There is only one person in #FORM.departmentName#.
            </CFOUTPUT>
        <CFELSE>
            <CFOUTPUT>
            <P>There are #numberInDepartment# people in
    #FORM.departmentName#.
            </CFOUTPUT>
        </CFIF>
    </CFIF>

    </BODY>
    </HTML>