Using a parameter in query:partial march

[Veli Izzet]

Hi all,

I want to input a parameter in a query for a partial match; i.e

I want the query to choose all the records that even partially matches
the data in the field. (like using the Like statement).

Thanks for any help.

 

[Guest]

You need to use the Like with *

Select * From TableName Where fieldName Like "*" & [Please enter value:] & "*"

 

[Veli Izzet]

Thanks..

You need to use the Like with *

Select * From TableName Where fieldName Like "*" & [Please enter value:] & "*"



:

Hi all,

I want to input a parameter in a query for a partial match; i.e

I want the query to choose all the records that even partially matches
the data in the field. (like using the Like statement).

Thanks for any help.