Search String for contains

[tsoley9262]

I created a search button that contains this search string ='('&replace(trim(replace(VSearch,',',' ') ),' ','|')&')', How can I change this so it searches on "Contains" right now it is just bringing back things that are equal to what I'm searching...Thanks

[zhadrakas · Accepted solution]

Try this:
='(*'&replace(trim(replace(VSearch,',',' ') ),' ','*|*')&'*)'

[tsoley9262]

Thanks worked like a charm!!