Re: LIKE operator. How does it work?

Billy Wheeler wrote: > I think the problem is that Informix doesn't record trailing spaces (open to > correction here) This seems like a rather artificial case, but you might also > try WHERE c MATCHES "* " Informix does not (by default) strip trailing spaces from varchars before they are inserted in the table. Sorry Billy, but MATCHES "* " doesn't work either. -- Sincerly, Doug Wilson(dougw@amgen.com) *** The opinions expressed here are my own and not neccessarily *** *** that of a rational human being . . . ************************** *** Disclaimer: These are the opinions of the poster not Amgen Inc.***