Wildcard using Mid statement (1 Viewer)

[harrisw]

Can anyone say what the syntax would be for the "incorrect" statement below?

Like *Mid([checking]![COMPANY NAME],1,InStr([checking]![COMPANY NAME]," "))*

As the statement above doesnt work, just returns errors.

Thanks in advance

 

[namliam]

Like """*" & Mid([checking]![COMPANY NAME],1,InStr([checking]![COMPANY NAME]," ")) & "*"""