Declare
Set @PathName varchar(100),@FileName varchar(100), @RStr varchar(100),@I int @PathName = 'D:\Rajeeva\Docs\File1.aspx'SET @RStr = Reverse(@PathName)SELECT @I = CHARINDEX('\', @RStr)Select @FileName = substring(@RStr,1,@I-1)PRINT Reverse(@FileName)
Set @PathName varchar(100),@FileName varchar(100), @RStr varchar(100),@I int @PathName = 'D:\Rajeeva\Docs\File1.aspx'SET @RStr = Reverse(@PathName)SELECT @I = CHARINDEX('\', @RStr)Select @FileName = substring(@RStr,1,@I-1)PRINT Reverse(@FileName)
