tolower and toupper return their argument values in lowercase and uppercase, respectively.
tolower(string-parameter)
toupper(string-parameter)
This example uses toupper to return the argument value in uppercase.
select xmlextract
('//book[title=”Seven Years in Trenton”]//toupper(first-name)', text_doc)
from sample_docs where name_doc='bookstore'
----------------------------------------
JOE
| Copyright © 2004. Sybase Inc. All rights reserved. |
|
|
