like clause is not working

[taree]

when I do a searhc for system / consultant, it does not find it. however, when I just do a search by system then it finds it. what wrong with my script. thank you for the help.

(if {?vendorBusinessDesc} <> ' ' then
{Command.BUSINESSDESC} like trim(uppercase("*"+{?vendorBusinessDesc}+"*"))
else True)

 

[lbass]

ucase(replace({Command.BUSINESSDESC}," ","")) like "*"+ucase(replace({?vendorBusinessDesc})," ",""))+"*"

I think the problem is with your interior spaces at least in part.

-LB