SELECT
dataCol1, case when len(dataCol1) - charindex(@urKeyWord , dataCol1 ) > 50 then substring(dataCol1,charindex(@urKeyWord , dataCol1 ),charindex(@urKeyWord , dataCol1 ) + 50 ) else substring(dataCol1,charindex(@urKeyWord , dataCol1 ),len(@urKeyWord) ) end
FROM
myTable
WHERE
dataCol2 NOT IN (SELECT col FROM anotherTable)
Advertisement
