String Functions MSSQL Tutorial

3> DECLARE @FullName VarChar(25)
4> SET @FullName = 'George Washington'
5> SELECT SUBSTRING(@FullName, CHARINDEX(' ', @FullName) + 1, LEN(@FullName))
6> GO
-------------------------
Washington
(1 rows affected)