Like operator problem (Oracle)

unknown_user3

I am writing SQL for a live report. My query works fine with SQL Plus tool. But when I copy same text in Live report it gives me error. Please help.select name from dtree where subtype in (128) and ParentID not in (2052, 2067) and name not like 'Temp Map -%'

Robert_Davies_(unlondonadmin_-_(deleted))

Message from Anne Callanan via eLinkYou possibly need two percentage signs for a livereportAnneeLink Discussion: Livelink LiveReports Discussion wrote:>Like operator problem (Oracle)>Posted by Kuncheria, Minu on 05/27/2007 08:49 AM>>I am writing SQL for a live report. My query works fine with SQL Plus tool. But when I copy same text in Live report it gives me error. Please help.>>select name from dtree where subtype in (128) and ParentID not in (2052, 2067) and name not like 'Temp Map -%'>>[To reply to this thread, use your normal E-mail reply function.]>>============================================================>>Discussion: Livelink LiveReports Discussion>https://knowledge.opentext.com/knowledge/llisapi.dll/open/2249677>>Livelink Server:>https://knowledge.opentext.com/knowledge/llisapi.dll>>To Unsubscribe from this Discussion, send an e-mail to unsubscribe.livereportsdiscussion@elinkkc.opentext.com.>>> >-- Anne CallananLivelink and Webboard Systems AdministratorLondon Metropolitan University166 - 220 Holloway RoadLondonN7 8DBDirect: 020 7133 3636Switchboard: 020 7423 0000 Ext. 3636 Ext.(79) 3636