sql statement

[bill d via AccessMonster.com]

hi there.

i have this line of code in my access
strSQL = "Select * from main where field like '" & strkey & "*'"

strkey is a variable which is pointing in memo field.
it works fine as it searches the first word in the field.
i want to modify it so it can serch any word in the field.

Please someone help me....

 

[Guest]

Simply put another asterix in the front part
..... like '*" & strkey & "*'"