SQL Query on an XMLObject CaseSensitive Resultset

[ColdFusion2]

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 for "UK" brings 13 records from the XML object "uk" no.

I have never read that it is case-sensitive.

I'm open to all suggestions.

Thank you greeting Jochen

[Dan_Bracuk]

if you need a case insensitive query do something like  where upper(something) = #ucase(something)#

[duncancumming]

I believe it's commonly known that it's case sensitive. e.g. it's documented here:

http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=using_recordsets_7.html

"Unlike the rest of ColdFusion, Query of Queries is case-sensitive. However, Query of Queries supports two string functions, UPPER() and LOWER(), which you can use to achieve case-insensitive matching."

[ColdFusion2]

hi,
many thanks for the quick response.
I'm still a beginner.
Best regards, Jochen