Very Simple Query using "like" 1

[fred45]

i've a table with let's say these entries :
car
van
bus
caravan

i want to create a simple query which prompts the user to enter a searchstring, scans the table and give the result.

let's say the user enters a string "van"
i want the query to produce "van" and "caravan"

i know i've got to use the "like" expression but i don't know how.

i think it's something like ---> like *[entry]*
but i don't know exactly where to place the asterix?

i just want to use a simple query, no forms as such.

pleas help.

 

[Databaseguy]

Like "*" & [Entry] & "*"
Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy