XQuery string functions

Question

XQuery string functions

seth delconte

SSCertifiable

Points: 6388
More actions
June 6, 2012 at 11:24 pm

#270267

Comments posted to this topic are about the item XQuery string functions
_________________________________
seth delconte
http://sqlkeys.com
June 7, 2012 at 7:37 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 20 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

Nice question about something I will never ever use 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

bornsql SSC-Addicted Points: 496 More actions · Answer 2

XQuery supports four string manipulation functions:

concat() Helps concatenate two or more strings.

contains() Helps determine whether or not a string specified as the first operand contains another string specified as the second operand. The length of the search string is limited to 4,000 Unicode characters.

substring() Helps extract portion of a string from another string known as source string.

string-length() Helps calculate the length of a string.

sanjeewan99 Say Hey Kid Points: 700 More actions · Answer 3

sanjeewan99

Say Hey Kid

Points: 700

June 7, 2012 at 1:56 am

#1498025

Nice easy question 🙂 Thanks

Ron McCullough SSC Guru Points: 63877 More actions · Answer 4

Would have thought that the supporting documentation would have been

http://msdn.microsoft.com/en-us/library/ms189254

Above is, in my humble opinion a much stronger support for the correct answer.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Dalton Moore SSC Eights! Points: 879 More actions · Answer 5

Answer choices were sooo much easier to read than yesterday's 😛

EL Jerry SSCertifiable Points: 7063 More actions · Answer 6

Nice and easy. Thanks, Seth. I also agree with Ron about reference documentation.

"El" Jerry.

"A watt of Ottawa" - Gerardo Galvan

To better understand your help request, please follow these best practices.[/url]

BarbW SSCarpal Tunnel Points: 4759 More actions · Answer 7

I agree with Dalton! 🙂 Also, it would be nice to have a "starts-with" function...

sestell1 SSChampion Points: 10230 More actions · Answer 8

Koen Verbeeck (6/6/2012)
Nice question about something I will never ever use 😀

I didn't think I'd ever use it either (I can't stand XML), but I've actually run across it twice now. Once when trying to search ReportServer databases for certain column references, and once when poking around in the plan cache for querys performing table scans. :-/

Cliff Jones SSChampion Points: 10547 More actions · Answer 9

I had no clue but made a lucky guess. So maybe I should buy a lottery ticket today ...

OzYbOi d(-_-)b SSCarpal Tunnel Points: 4054 More actions · Answer 10

OzYbOi d(-_-)b

SSCarpal Tunnel

Points: 4054

June 7, 2012 at 8:52 am

#1498228

thanks for the question - cheers

Revenant SSC-Forever Points: 42467 More actions · Answer 11

Revenant

SSC-Forever

Points: 42467

June 7, 2012 at 9:22 am

#1498247

Nice question - thanks!

Ken SSCoach Points: 17191 More actions · Answer 12

Thanks for the question! I don't think I will ever use XQuery either but it's good to research these things anyways.

TomThomson SSC Guru Points: 104773 More actions · Answer 13

Nice straightforward unambiguous question.

Of course it's about a nonstandard implementation of something designed to query the overhyped and much misused XML format, with which sensible people want as little to do as possible; but it's still an admirably clear and simple question.

Tom