0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

DECLARE @str VARCHAR(50)
SET @str = '/folder@root/folder@home/folder@user/folder@reports/package@pack12/report@r12'
SELECT  


substring('/content/folder[@name=''CORPORATE'']/folder[@name=''ITSUS'']/folder[@name=''ATHENA'']/folder[@name=''IncidentMgmnt - R2'']
/folder[@name=''Reports'']',charindex('=','/content/folder[@name=''CORPORATE'']/folder[@name=''ITSUS'']/folder[@name=''ATHENA'']/folder[@name=''IncidentMgmnt - R2'']
/folder[@name=''Reports'']',1)+2,  
charindex(']','/content/folder[@name=''CORPORATE'']/folder[@name=''ITSUS'']/folder[@name=''ATHENA'']/folder[@name=''IncidentMgmnt - R2'']
/folder[@name=''Reports'']',1)-charindex('=','/content/folder[@name=''CORPORATE'']/folder[@name=''ITSUS'']/folder[@name=''ATHENA'']/folder[@name=''IncidentMgmnt - R2'']
/folder[@name=''Reports'']',1)-2)

fork query

edited jul 24 13

created feb 6 12 anonymous