similar to a soundex search?

[Jen0dorf]

Hi

I'm using the code

Like [TempVars]![varBaptismForename] & "*"

in a query.



Does the &"*" act like a soundex search ?

thanks

Ian

[John_G]

No. The "Like" is used for pattern matching, with the "*" being a "wild card" meaning "anything that follows".

So, if
[TempVars]![varBaptismForename] = "Jon", then Like [TempVars]![varBaptismForename] & "*"

will match "Jon", "Jonathan", "Jonas" or "Jones", but it will not match "John", "Jane" or "Joan"

[Jen0dorf]

MAny thanks for the elucidation

IAn

Hi

I'm using the code

Like [TempVars]![varBaptismForename] & "*"

in a query.

Does the &"*" act like a soundex search ?

thanks

Ian