Query that contains the word "Maria"

[valterduarte]

Hello!

I have a basic question, which I'll explain with an example:

I have a table with 3 fields:

ID
Full Name
Birth Date

How do I build a query that searches all the records that contain the word "Maria" in the Full Name field?

Thank you!

 

[Remou]

As in:
SELECT *
FROM tblTable
WHERE tblTable.[Full Name] Like "*maria*"

?

 

[ZmrAbdulla]

[tt]Like [Enter the name]& "*"[/tt]

________________________________________________________
Zameer Abdulla
Help to find Missing people
Do not cut down the tree that gives you shade.