Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

XQuery string functions Expand / Collapse
Author
Message
Posted Wednesday, June 6, 2012 11:24 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 12:10 PM
Points: 1,619, Visits: 1,236
Comments posted to this topic are about the item XQuery string functions

_________________________________
seth delconte
http://sqlkeys.com
Post #1312298
Posted Wednesday, June 6, 2012 11:45 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:46 AM
Points: 13,528, Visits: 11,324
Nice question about something I will never ever use



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1312303
Posted Thursday, June 7, 2012 1:49 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 12:31 AM
Points: 104, Visits: 313
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.
Post #1312336
Posted Thursday, June 7, 2012 1:56 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 11:26 PM
Points: 116, Visits: 397
Nice easy question Thanks
Post #1312338
Posted Thursday, June 7, 2012 6:52 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, November 6, 2014 1:00 PM
Points: 5,333, Visits: 25,277
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

Before posting a performance problem please read
Post #1312451
Posted Thursday, June 7, 2012 7:36 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, May 28, 2013 6:23 AM
Points: 419, Visits: 228
Answer choices were sooo much easier to read than yesterday's
Post #1312496
Posted Thursday, June 7, 2012 7:37 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 6:20 AM
Points: 4,104, Visits: 5,462
Good question, thanks.

However, I must agree with Ron....


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1312498
Posted Thursday, June 7, 2012 7:41 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 1:50 PM
Points: 3,798, Visits: 1,221
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.
Post #1312504
Posted Thursday, June 7, 2012 7:41 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, November 21, 2014 9:08 AM
Points: 2,625, Visits: 1,056
I agree with Dalton! Also, it would be nice to have a "starts-with" function...
Post #1312505
Posted Thursday, June 7, 2012 7:48 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 7:08 AM
Points: 1,392, Visits: 2,402
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. :-/
Post #1312510
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse