Mega Code Archive

 

Categories / MSSQL Tutorial / String Functions

 

Get the last name

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)