PLS TRY BELOW CODE.

DECLARE @T1 TABLE(ID INT,NAME VARCHAR(30))

INSERT INTO @T1(ID,NAME)

SELECT 1,'AA'

UNION

SELECT 2,'BB'

UNION

SELECT 3,'"Application''s"'

UNION

SELECT 4,'"Application"'

SELECT * FROM @T1

WHERE NAME LIKE '"Application%'