• I think this is a slightly shorter solution.

    LastName = reverse(left(reverse(FullName), charindex(' ', reverse(FullName)) - 1))