>Archive Index
>microsoft.public.xml Archive Home
>Recent entries

[Thread Prev]
>Thread Next - Re: lower-case()-Function in XQuery

lower-case()-Function in XQuery

From: "Lars Berner" <ltrader@---------------.-->
To: NULL
Date: 8/3/2006 1:44:00 PM


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:



-- 
Kind regards

Lars Berner
MCAD

[Thread Prev]
>Thread Next - Re: lower-case()-Function in XQuery

>Archive Index
>microsoft.public.xml Archive Home
>Recent entries

Altova Mailing List Archives

lower-case()-Function in XQuery