Excuse-me, was my mistake.
Right
Link is
Or in
the tree:
Reference Manual, Basic Elements, Predicate, LIKE
Predicate.
-----Mensagem original-----
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Enviada em: Saturday, November 02, 2002 8:07 PM
Para: Edson Carlos Ericksson Richter
Assunto: Re: RES: Problem with LIKE
Hi Edson,
Thanks for the quick response.
That works like a charm but I cannot find the specific reference you are referring to from your link. The link takes me to the start of the Reference Manual.
I would appreciate it if you could tell me the sections of this manual which I need to read.
Thanks in advance
-Mohamed
"Edson Carlos Ericksson Richter" <[EMAIL PROTECTED]> 11/02/2002 07:58 PM
"Mohamed Koker" <[EMAIL PROTECTED]> RES: Problem with LIKE
Can you try
where drug_name like 'ALLEGRA :(12HOUR)%'ESCAPE':'
?
See details at
http://www.sapdb.org/htmhelp/e0/ed9036dfe4b903e10000009b38f889/frameset.htm
Good luck!
Edson Richter
-----Mensagem original-----
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Em nome de Mohamed Koker
Enviada em: Saturday, November 02, 2002 7:14 PM
Para: [EMAIL PROTECTED]
Assunto: Problem with LIKE
Hi All,
If execute the following query, I do not get any results:
select * from drug
where drug_name like 'ALLEGRA (12HOUR)%'
while the query
select * from drug
where drug_name = 'ALLEGRA (12HOUR)'
returns a result set.
Similarly, the query
select * from drug
where drug_name like 'ALLEGRA ((12HOUR)%'
returns a result set but with too many rows.
Can someone please explain the rules for the LIKE predicate ?
Cheers
-Mohamed
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
---
E-Mail recebido est� sem virus.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.410 / Virus Database: 231 - Release Date: 10/31/2002
---
Email foi verificado quanto a exist�ncia de virus antes de seu envio, e n�o
h� virus.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.410 / Virus Database: 231 - Release Date: 10/31/2002
