DECLARE @SQL NVARCHAR(1000)
SET @SQL = 'SELECT * FROM MyTable WHERE Field1 = ''AAA'''
EXECUTE(@SQL)

DECLARE @SQL NVARCHAR(1000)
SET @SQL = 'SELECT * FROM MyTable WHERE Field1 = @Field1'
EXECUTE sp_executesql @SQL, N'@Field1 VARCHAR(10)', 'AAA'

select 'it''s escaped'

it's escaped

SELECT columns FROM table
WHERE column LIKE '%%%' ESCAPE ''

SELECT colA, colB, colC
FROM tableD
WHERE colA = 'John''s Mobile'