select data

[newssis]

Hi all,

I have data in table like this :

c:/file/datapart/datafile/filename.xls

and only want to return filename.xls or any other file extension but not whole path.

how can i do that.

Thanks
Pat

 

[RiverGuy]

Try this

DECLARE @t TABLE (PathColumn VARCHAR(100))
INSERT INTO @t SELECT 'c:/file/datapart/datafile/filename.xls'

SELECT REVERSE(LEFT(REVERSE(PathColumn), CHARINDEX('/', REVERSE(PathColumn)) - 1)) FROM @t