SQLWebpedia

Declare @FileName1Dir varchar(500), @FileName1File varchar(100), @FileName1 varchar(500)

Set @FileName1='c:\Report5_xml\report_5_1.xml' 

--Get Folder name
SELECT @FileName1Dir = REVERSE(RIGHT(REVERSE(@FileName1),(LEN(@FileName1)-CHARINDEX('\', REVERSE(@FileName1),1))+1))
--Get File name
,@FileName1File = REVERSE(LEFT(REVERSE(@FileName1),CHARINDEX('\', REVERSE(@FileName1),1)-1))