Manipulate a string using SQL

[douggy]

Hi there,

I have a string in a field which contains a document path.

example:

~/User/Documents/TGEACASE.PRT

I would like to extract just the file name. i.e everything after ~/User/Documents/

Any pointers on how to do this would be appreciated.

Regards
Mark

 

[PerlyGates]

Try this ...

DECLARE @str varchar(100)
SET @str = '~/User/Documents/TGEACASE.PRT'
SELECT SUBSTRING( @str, LEN(@str) - CHARINDEX('/', REVERSE(@str)) + 2 , LEN(@str) )