DECLARE @filename_with_path AS VARCHAR(256)SET @filename_with_path = '/fo/oo/bar.txt'SELECT RIGHT(@filename_with_path, CHARINDEX('/', REVERSE(@filename_with_path)))