SQL Query on an XMLObject CaseSensitive Resultset

hi there,
i make a sql query on an object with dbtype = query
<cfquery name="qry_catalog" dbtype="query">
select * from catalog query
where country like '# art #'
</ cfquery>

what also goes without problems, interestingly, the query takes only results when the upper / lower case is correct.
e.g. search "uk" brings 13 records from xml object "uk" no.

i have never read that it is case-sensitive.

i'm open to all suggestions.

thank you greeting jochen

if need case insensitive query like  upper(something) = #ucase(something)#

More discussions in ColdFusion

adobe