Help with LIKE Syntax conversion

[dj_mix]

Hello

I'm trying to convert my exsting LIKE Command to search Contians a word.

Example currently it will search for word starting with word in the search box.

I type in 2006, it will only look for project names starting with 2006.

I would like to Motify the search to "Contain" 2006 in the field anywhere.

Here's the code I like to convert.

"SELECT * FROM [qryProjects]" & "[PROJECT] LIKE """ & Me.txtSearchString2 & "*"" AND "

 

[FoFa]

Put the astrik in front of and behind the target
LIKE "*anything*"

 

[dj_mix]

Got it to work

"SELECT * FROM [qryProjects]" & "[PROJECT] LIKE ""*" & Me.txtSearchString2 & "*"" And "