3> DECLARE @FullName VarChar(25)
4> SET @FullName = 'George Washington'
5> -- Return first name:
6> SELECT SUBSTRING(@FullName, 1, CHARINDEX(' ', @FullName) - 1)
7> -- ^String ^Start ^Returns space index ^Don't include space
8> GO
-------------------------
George
(1 rows affected)