Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. VIJGAN

    Write SQL which grab only email address

    DECLARE @s VARCHAR(100) SET @s = 'X400:c=US;a=KNA;p=Enterprise;o=KNA US New Jersey;s=Burke;g=Andrew;i=P;%SMTP:BurkeA@xyz.com' SELECT SUBSTRING(@s, CHARINDEX('SMTP:', @s)+ 5, LEN(@s) - (CHARINDEX('SMTP:', @s)+ 4))

Part and Inventory Search

Back
Top