Home Forums SQL Server 2005 SQL Server 2005 Integration Services sql statement to get before '@' from email address RE: sql statement to get before '@' from email address

  • October 25, 2013 at 2:57 pm

    #1661746

    Hi Scuby,

    Try this.

    select REPLACE(SUBSTRING(Your_Column,1,CHARINDEX('@',Your_Column)),'@','') Name from Your_Table NOLOCK

    Thanks

    sibi.