There's probably a cool way to do this with xml, but declare @str varchar(50) = '\Credit\Input\Shared\Docs \logs\logo\docu\doc' select SUBSTRING(@str,9, LEN(@str)- PATINDEX('%\logs%',@str))
Jim
Everyday I learn something that somebody else already knew
Unfortunately I don't know if there is an XML way of doing this, I just thought there might be because of the format of the data. I am not terribly familiar with XML.
Jim
Everyday I learn something that somebody else already knew
Extract a variable string from a column using SQl
Posted - 07/02/2012 : 08:30:16
