Please check this query
SQL
DECLARE @Links TABLE (Url VARCHAR(100))
INSERT @Links VALUES ('../../../master/StateMasterview.aspx')
INSERT @Links VALUES ('../../../utility/CompanyMasterView.aspx')
INSERT @Links VALUES ('../../../Report/Sales/RptSalesBill.aspx')
SELECT REVERSE(RTRIM(SUBSTRING(REVERSE(Url),1,CAST((CHARINDEX('/',REVERSE(Url))) AS INT) - 1))) AS PageName
FROM @Links
Output
PageName
------------------
StateMasterview.aspx
CompanyMasterView.aspx
RptSalesBill.aspx