DECLARE @email varchar(64) SET @email = 'John.Doe@abc-stago.com' SELECT LEFT(@email, CHARINDEX('.', @email)-1) AS fname, SUBSTRING(@email, CHARINDEX('.', @email)+1, CHARINDEX('@', @email) - CHARINDEX('.', @email)-1) AS lname>Can anyone suggest the syntax for extracting first name and last name from an email address within a sql table.