Get last word of a string in sql server

////////////////////// sql script

Declare @Str varchar(100)='this-is-only-for-test',@Para varchar(10)='-'

SELECT substring(@Str,LEN(@Str) - CHARINDEX(@Para,REVERSE(@Str))+2,LEN(@Str)) AS Result

/////////////////result