KB18204: What is the difference between 'Contains' and 'Like' qualification operators when defining filters in MicroStrategy Developer?

Users may want to know what the difference is between 'Contains' and 'Like' qualification operators when defining filters in Strategy Developer. This is described below:
 
'Like' Qualification operator:

SQL Generated:

select a11. AS CATEGORY_ID,
a11. AS CATEGORY_DESC
from a11
where a11. like 'Book'

 
'Contains' Qualification operator:

SQL Generated:

select a11. AS CATEGORY_ID,
a11. AS CATEGORY_DESC
from a11
where a11. like '%Book%

 
The 'Contains' operator adds a wild character automatically to the search string, while the 'Like' operator matches for the exact search string.