How to use wildcard?

[Anima]

i've try and no luck... using Like "*[*]*"

i'm tryin to create one that if i search for like let say "brisbane" it would show the results of the complete spelling, but let say if i was to just type "b" or "bris" it would show u a list of "B" towns or matching words of "bris".

any assit would be great

 

[Michael J Ross]

Like "*"&[search value]&"*"