Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004

    Question Unanswered: Something like charindex

    I need to find the position of the last occurence of a symbol in a field.
    Eg: "ABC/DEF/GHI"

    Charindex would look at the 1'st occurence of "/".

    Is there a simple way to get the last "/"?

  2. #2
    Join Date
    Dec 2004
    Broomfield, Colorado

    charindex - xednirahc

    I'm running short on time at this moment.... have to run.... but in the meantime take a look at the "reverse" function. I had a similar problem once and recall flipping the string around finding the "first occurance' and then flipping it back...

    I will try to post an example later.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts