SELECT        UserID, Username, Email, FullName, Initials
FROM            Users
set Initials = (select left(Email, charindex('@', Email + '@')-1)

update Users
     set Initials = left(Email, charindex('@', Email + '@')-1)