Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 3. Path Enumeration Models > 3.7. Splitting up a Path String

3.7. Splitting up a Path String

Because the path string contains information about the nodes in the path it represents, you will often want to split it back into the nodes that created. This is easier to do if the path string was built with a separator character such as a comma or slash; I use a slash so this will look like a directory path in UNIX. You will also need a table called Series, which is a set of integers from 1 to (n).
CharIndex(<search string>, <target string>, <starting position>) is a vendor version of the Standard SQL function POSITION(<search string> IN <target string>). It begins the search at a position in the target string, thus when the <starting position> = 1, the two are equivalent. It can be defined as

  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint