XQuery string functions

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

    _________________________________
    seth delconte
    http://sqlkeys.com

  • 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

  • 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.

  • Nice easy question 🙂 Thanks

  • 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]

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

  • This was removed by the editor as SPAM

  • 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]

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

  • 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. :-/

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

  • thanks for the question - cheers

  • Nice question - thanks!

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

  • 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 20 total)

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