Using a parameter in query:partial march

V

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.
 
O

Ofer

You need to use the Like with *

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

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.
Click to expand...
Click to expand...
 
Top