How do I add a wildcard to an input value?

Jonathan_Thomson_(jonathanthomson_-_(deleted))

Is it possible to add a wildcard to a user input value, for example....WHERE (Theme Like %1 '%%' OR Theme__2_ Like %1 '%%' OR Theme__3_ Like %1 '%%')If the user enters for example "fr" it finds "Fraud".

Lindsay_Davies

Message from Lindsay Davies via eLinkHow you do that depends on the DB you are using.You need to concatenate the escaped % character. In Oracle this would be as follows.... theme like %1 || '%%' In SQL server, theme like %1 + '%%'RegardsLindsayOpen TextUK-Support-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 16 January 2007 11:38To: eLink RecipientSubject: How do I add a wildcard to an input value?How do I add a wildcard to an input value?Posted by Thomson, Jonathan on 01/16/2007 06:35 AMIs it possible to add a wildcard to a user input value, for example....WHERE (Theme Like %1 '%%' OR Theme__2_ Like %1 '%%' OR Theme__3_ Like %1'%%')If the user enters for example "fr" it finds "Fraud". [To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/llisapi.dllTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.