geoff5 (7/30/2013)
I think this is a slightly shorter solution.
LastName = reverse(left(reverse(FullName), charindex(' ', reverse(FullName)) - 1))
How is that shorter and why do you believe that 3 REVERSEs are better than 1?
--Jeff Moden
Change is inevitable... Change for the better is not.