<cfcomponent>
    <cffunction name="queryNames" access="remote">
        <cfargument name="searchPhrase" />

        <cfquery name="query_names" maxrows="10" dbtype="query">
            SELECT    Name
            FROM      names_table
            WHERE     LOWER(Name) LIKE <cfqueryparam cfsqltype='cf_sql_varchar' value="%#LCASE(arguments.searchPhrase)#%" />
            ORDER BY  Name
        </cfquery>

        <cfset result = arrayNew(1) />

        <cfloop query="query_names">
            <cfset ArrayAppend(result, query_names.Name) />
        </cfloop>

        <cfreturn result />
    </cffunction>
</cfcomponent>