Quick thought, use the LIKE operator

😎

USE tempdb;

GO

DECLARE @test-2 TABLE

(

TEST_ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED

,TEST_STRING VARCHAR(50) NOT NULL

);

INSERT INTO @test-2(TEST_STRING)

VALUES

('I am a bad Gal')

,('I am a good Gal')

,('This is an old horse')

,('This is a good horse')

,('I am a good boy')

,('I am a naugthy boy');

SELECT

*

FROM @test-2 T

WHERE T.TEST_STRING LIKE '%good%';

Results

TEST_ID TEST_STRING

----------- ---------------------

2 I am a good Gal

4 This is a good horse

5 I am a good boy