selecting a text in a column

DECLARE @st VARCHAR(100)='From: 1@hotmail.com [mailto:jacquelinerobson61@hotmail.com]'



SELECT SUBSTRING(@st,CHARINDEX (' ',@st),CHARINDEX ('.',@st)-1)

---

Best Regards,Uri Dimant SQL Server MVP, http://ift.tt/1iQ9JkR



MS SQL optimization: MS SQL Development and Optimization

MS SQL Consulting: Large scale of database and data cleansing

Remote DBA Services: Improves MS SQL Database Performance

SQL Server Integration Services: Business Intelligence