MatchPattern wildcard % behavior in Webi report

Hi,

I have a requirement where user don't want to put wildcard (%) in start and end of the string to search into database from webi report Prompt.

Is there any way to add wildcard in user input string start and end like %xxxxxx%

User input : xxxxxx

String requirement to hit DB for search pattern : %xxxxxx%

SAP BO version : 4.2 sp9

Report is on top of IDT single source universe

underlined database : SQL server

Thank you very much!

Nav