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
