LIKE statements with wildcards & punctuation

Help! Does anyone know how to do livereports using the LIKE statement using wildcards and punctuation. I'm trying to search for items strings likeAPQ Log 'WL'where the WL will be a wildcard. The problem I have is I need the ' symbol in the statement but livelink thinks this is the end of the string.

Find more posts tagged with

Comments

eLink User

Message from Trevor Sharpe via eLinkselect * from dtree where name like 'McDonald''s%'I think this is right. two single quotes escapes the second, and the % meanseverything like this, rather than an exact match.-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: March 6, 2002 8:52 AMTo: eLink RecipientSubject: LIKE statements with wildcards & punctuationLIKE statements with wildcards & punctuationPosted by BUPAAdmin on 03/06/2002 08:49 AMHelp! Does anyone know how to do livereports using the LIKE statement usingwildcards and punctuation. I'm trying to search for items strings likeAPQ Log 'WL'where the WL will be a wildcard. The problem I have is I need the ' symbolin the statement but livelink thinks this is the end of the string.[To reply to this thread, use your normal e-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

eLink User

Message from Xu Moua via eLinkWe recommend not to use special characters (i.e. ', &, (, )... etc) innaming your Livelink items. But, at any rate you can escape the singlequote with another single quote.Example:Select * from dtree where name like '%%''WL''%%'Note: In LiveReports you must escape the wildcard (%) as well.Hope that helps.Xu-----Original Message-----From: knowledge@opentext.com [mailto:knowledge@opentext.com] On BehalfOf eLink Discussion: Livelink LiveReports DiscussionSent: Wednesday, March 06, 2002 8:52 AMTo: eLink RecipientSubject: LIKE statements with wildcards & punctuationLIKE statements with wildcards & punctuationPosted by BUPAAdmin on 03/06/2002 08:49 AMHelp! Does anyone know how to do livereports using the LIKE statementusing wildcards and punctuation. I'm trying to search for items stringslikeAPQ Log 'WL'where the WL will be a wildcard. The problem I have is I need the 'symbol in the statement but livelink thinks this is the end of thestring.[To reply to this thread, use your normal e-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server: https://knowledge.opentext.com/knowledge/livelink.exe

Campina_Admin_(x-campadmin_-_(deleted))

Hi,I want to make a livereport where the imput value is a variable:select * from dtree where '%%' '%1' '%%' this results in an error.I use an Oracle databaseThanks Remco

eLink User

Message from Marie Lindsay <<A HREF="mailto:marie@opentext.com">marie@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Try '%%%1%%' instead.

-----Original Message-----
From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf Of eLink Discussion: Livelink LiveReports Discussion
Sent: Monday, March 11, 2002 8:14 AM
To: eLink Recipient
Subject: wildcards with userinput value

wildcards with userinput value Posted by CampAdmin (Van Steenbergen, Remco ) on 03/11/2002 09:11 AM
In reply to: RE LIKE statements with wildcards & punctuation 2 Posted by eLink on 03/06/2002 09:15 AM

Hi,

I want to make a livereport where the imput value is a variable:

select * from dtree where '%%' '%1' '%%' this results in an error.
I use an Oracle database

Thanks

Remco

Alex_Kowalenko_(akowalen_(Delete)_2285456)

Well, '%%''%1''%%' is a non seqiutur.What does %1 stand for? This has a bearing on what Oracle is trying to parse.If you want to do a LIKE with widlcard in Oracle the LiveReport syntax is something like this:LIKE '%%' || ' or ' || '%%

Alex_Kowalenko_(akowalen_(Delete)_2285456)

A wayward keystroke hijacked my reply...Let me complete it:If you want to do a LIKE with wildcards in Oracle, then the LiveReport syntax can be something like this:LIKE '%%' || '' or || '%%'

kumar123

I am facing same problem for ms sql can any body suggest me answer

kumar123

I tried '%%'+%1+'%%' it worked