When using the SQL LIKE operator, what is the correct way to wrap the search text to return all appearances?

'search text'

$*$search text$*$

$\%$search text$\%$

"search text"