XQuery string functions

  • seth delconte

    SSCertifiable

    Points: 6388

    Comments posted to this topic are about the item XQuery string functions

    _________________________________
    seth delconte
    http://sqlkeys.com

  • Koen Verbeeck

    SSC Guru

    Points: 258938

    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: 476

    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

    Nice easy question 🙂 Thanks

  • Ron McCullough

    SSC Guru

    Points: 63877

    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: 869

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

  • This was removed by the editor as SPAM

  • EL Jerry

    SSCertifiable

    Points: 7053

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

    "El" Jerry.

    "El" Jerry.

    "A watt of Ottawa" - Gerardo Galvan

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

  • BarbW

    SSCarpal Tunnel

    Points: 4699

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

  • sestell1

    SSChampion

    Points: 10230

    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: 10517

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

  • OzYbOi d(-_-)b

    Hall of Fame

    Points: 3944

    thanks for the question - cheers

  • Revenant

    SSC-Forever

    Points: 42467

    Nice question - thanks!

  • Ken Wymore

    SSCoach

    Points: 16385

    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: 104772

    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

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

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