Quote:[^]specific Internet identifier that contains a locally interpreted string followed by the at-sign character ("@", ASCII value 64) followed by an Internet domain.
DECLARE @ID AS NVARCHAR(30)='Help@Codeproject.Com' SELECT SUBSTRING(@ID,CHARINDEX('@',@ID)+1,LEN(@ID)) OR SELECT RIGHT(@ID,(LEN(@ID)-CHARINDEX('@',@ID)))
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)