Home Forums SQL Server 2008 T-SQL (SS2K8) Need Help TSQL Code. RE: Need Help TSQL Code.
geoff5
Hall of Fame
Points: 3560
More actions
July 30, 2013 at 3:34 pm
#1637145
I think this is a slightly shorter solution.
LastName = reverse(left(reverse(FullName), charindex(' ', reverse(FullName)) - 1))