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)