selecting a text in a column

This?

CREATE TABLE #t (id VARCHAR(100))

INSERT INTO #t VALUES ('From: 1@hotmail.com [mailto:jacquelinerobson61@hotmail.com]')

INSERT INTO #t VALUES ('From: 2@hotmail.com [mailto:jacquelinerobson62@hotmail.com]')





DECLARE @var VARCHAR(100)='1@hotmail'



SELECT * FROM #t WHERE id LIKE '%'+@var+'%'

---

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