Re: Reverse string matching

2001-09-30 Thread Benjamin Pflugmann
Hi. On Mon, Oct 01, 2001 at 12:37:58AM +0800, [EMAIL PROTECTED] wrote: > On Sun, Sep 30, 2001 at 11:07:37AM -0500, Gunter Leeb wrote: > > Hi, > > > > Consider Name LIKE 'ABC%' finds all names that start with ABC. > > > > I am looking for the reverse: I have a string and I am looking for > > all

Re: Reverse string matching

2001-09-30 Thread Michael C. Alonzo
On Sun, Sep 30, 2001 at 11:07:37AM -0500, Gunter Leeb wrote: > Hi, > > Consider Name LIKE 'ABC%' finds all names that start with ABC. > > I am looking for the reverse: I have a string and I am looking for all the records >that have a name which is the BEGINNING of this > string. As an example:

Reverse string matching

2001-09-30 Thread Gunter Leeb
Hi, Consider Name LIKE 'ABC%' finds all names that start with ABC. I am looking for the reverse: I have a string and I am looking for all the records that have a name which is the BEGINNING of this string. As an example: I have'ABCDE' and I want rows contains 'ABCD' or 'ABC' or just 'A' f