SQL query for Records containing a Character

[WWGD]

Hi All,
I am trying to do an SQL query for records containing a certain character, say, c , in 'field'

I think if the character c is at the beginning, we use :

Select ... from table
where field like 'c % ' , where % is a wildcard.

Similar for cases where the character is at the end, i.e., we would use :

Select ... from table
where field like '% c '.

But if the character c was somewhere in the middle , would we use :

Select ... from table
where field like '% c % ' ?

EDIT: I assume the last choice, '% c % ' covers all cases, since % may stand for an empty string.
Is this correct?
Thanks.

 

[newjerseyrunner]

Yes, everything you have said is correct.