Hello,

I have some issues in creating an XQuery Statement in an SQL Server 2005
Database.

I require to create a query which selects a resultset of data in a non case
seneitive manner in combination with the usage of the contains()-Function,
for example like that:
SELECT * FROM tblObjects WHERE XMLFields.value('

contains( (/allItems/item/fieldValue)[1],

lower-case("rtma"))','bit') = 1

As I figured out the problem seems to be that in SQL Server 2005 the
lower-case() Function seems to be not implemented.
I searched through web and somebody mentioned a possible workaround using
the SQL Function lower() like this:

declare @x xml
set @x='<a>ABC</a>'

select lower(@x.value('(/a/text())[1]', 'nvarchar(100)'))

I realy tried hard to figure out how to modify my query using the above
mentioned suggestion but I did'nt succeed.
I tried something like that without succeeding:

SELECT * FROM tblObjects
WHERE XMLFields.value(lower('
 contains( (/allItems/item/fieldValue[/allItems/item/fieldKey="Place"])[1],
    "rtma")'),'NVARCHAR(256)') = 1
Could anybody of you geeks help me modifying the Query?

Thank you in advance

-- 
Kind regards

Lars Berner
MCAD


-- 
Viele Grüße

Lars Berner
MCAD