My best shot:
SELECT *
FROM TableName
WHERE ColumnData Like '%The Safety%'
I tried above on below example:
DECLARE @tmp TABLE (SomeText VARCHAR(255))
INSERT INTO @tmp (SomeText)
VALUES('1. a. The Safety gate combined with one gate.'),
('b. The Safety gate combined with three gates.'),
('c. The Safety gate separated with others gates.')
SELECT *
FROM @tmp
WHERE SomeText Like '%The Safety gate%'
See:
Like (T-SQL)[
^]