MS Access Contains query -

how write contain query msaccess database

my table have column value ' chope parma tera 101'

my search keyword in parma.

how can write contain query retrieve record ?

query in ms access:

select * sometable somecolumn '* parma *' 

for standard sql, '% parma %'

note above statement not find 'parma', 'chope parma', or chope parmaham 101', or value contains parma; remove spaces in search string, e.g. '*parma*'

select * sometable somecolumn '*parma*'