Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. buckshot323

    SQL - Charindex/Substring - How to get 6 characters left of 3rd or last '/'

    So this right( orgpathtxt, CHARINDEX( '/', REVERSE( orgpathtxt ) + '/' ) + 6), is giving me the 6 digits plus the slash and all the contents to the right. So if the string is 'Organization/SIS/RND 434444/CIT' It's bringing back 434444/CIT
  2. buckshot323

    SQL - Charindex/Substring - How to get 6 characters left of 3rd or last '/'

    I have found some code to find the last occurrence of it in the string, but for the life of me I can't figure out the last piece to pull the 6 digits to the left of the '/'. I'm not savvy enough, and that's why I posed this question looking for help. I always end up pulling all data to the...
  3. buckshot323

    SQL - Charindex/Substring - How to get 6 characters left of 3rd or last '/'

    I have a field-string in a table that displays like this: Organization/SIS/RND 434444/CIT All characters could be different in all areas minus the 'Organizaiton/' part and the '/' which will always be three. For example CIT could be 2 characters, or 3 characters or more. What I need is to...

Part and Inventory Search

Back
Top