SQL Server String: Get File Name from Full File path

DECLARE @FullPath NVARCHAR(500) = N'D:\Itai\Tasks\MyFile.csv'

SELECT LEFT(@FullPath,LEN(@FullPath) - charindex('\',reverse(@FullPath),1) + 1) AS OnlyPath,

       RIGHT(@FullPath, CHARINDEX('\', REVERSE(@FullPath)) -1) AS OnlyFileName