search part of field with query

[takis_x]

Hello to all!!!!!!
I have an mp3 database,with a table that has columns for artist,title ect. The artist column has fields like "dead can dance". I want to create a query that searches the db for a name so that i can see all the records but stting as criteria part of the name instead of setting as criteria the entire name of the field.Can this be done?Any help would be appreciated!!!!!!!!
Thanks alot!!!!!!!!!!

 

[Rich]

Look up the Like operator, there have been many examples posted here