CREATE TABLE EmailInfo(
ID INT IDENTITY(1,1),
emails VARCHAR(MAX)
)
CREATE TABLE KeywordInfo (
ID INT IDENTITY(1,1),
keywords VARCHAR(MAX)
)
INSERT INTO KeywordInfo VALUES('webmaster')
INSERT INTO KeywordInfo VALUES('webcom')
INSERT INTO KeywordInfo VALUES('master ')
INSERT INTO EmailInfo VALUES('Email FOr WebMaster')
INSERT INTO EmailInfo VALUES('Email For Web')
INSERT INTO EmailInfo VALUES('Email FOr Master')
INSERT INTO EmailInfo VALUES('Email FOr WebCom')
INSERT INTO EmailInfo VALUES('Email FOr tejas')
DECLARE @QUERY VARCHAR(MAX) = ''
DECLARE @SELECT VARCHAR(MAX) = 'SELECT emails FROM EmailInfo WHERE emails '
DECLARE @WHEREFiled VARCHAR(MAX) = ' AND emails '
DECLARE @LIKE VARCHAR(MAX) = ' NOT LIKE '
DECLARE @LASTLike VARCHAR(MAX) = ' NOT LIKE '''''
DECLARE @Temp VARCHAR(MAX) = ''
SELECT @Temp = @Temp + @LIKE + '''%'+keywords+'%''' + @WHEREFiled FROM KeywordInfo
SET @QUERY = @SELECT + @Temp + @LASTLike
EXEC(@QUERY)
here i have demonstrat a dynamic sql you can modify it using your fileds and values