home contribute faq download

FunctX XQuery Functions

functx:sort-case-insensitive

Sorts a sequence of values or nodes regardless of capitalization

Google
Webxqueryfunctions.com

Description

The functx:sort-case-insensitive function sorts a sequence of values or nodes without regard to whether they are upper or lower-case. Normally, using most collations, all upper-case letters are sorted before all lower-case letters, so "Z" would come before "a". It returns the items in their original capitalization.

Arguments and Return Type

NameTypeDescription
$seq item()* the sequence to sort
return value item()*

XQuery Function Declaration

See XSLT definition.
declare namespace functx = "http://www.functx.com";
declare function functx:sort-case-insensitive
  ( $seq as item()* )  as item()* {

   for $item in $seq
   order by upper-case(string($item))
   return $item
 } ;

Examples

let $in-xml :=
<in-xml>
  <f>a</f>
  <f>c</f>
  <e>B</e>
</in-xml>
return
XQuery ExampleResults
functx:sort-case-insensitive(('a','c','B'))
('a', 'B', 'c')
functx:sort-case-insensitive($in-xml/*)
<f>a</f>
<e>B</e>
<f>c</f>

See Also

functx:sortSorts a sequence of values or nodes
functx:sort-as-numericSorts a sequence of numeric values or nodes
functx:sort-document-orderSorts a sequence of nodes in document order

History

Published OnLast UpdatedContributor(s)
2006-06-272007-02-26Priscilla Walmsley, Datypic, pwalmsley@datypic.com, http://www.datypic.com
Datypic XQuery Services

Recommended Reading:

XQuery