<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>