Re: LIKE operator. How does it work?

> > When I use LIKE operator to retrieve strings with ended spaces > > SELECT C FROM T WHERE C LIKE '% ';> > I get all values stored in the table. Is this the right way to work > for Informix? > With Oracle, the previous SQL statement retrieves only strings with > ended spaces as requested. 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 "* " HTH. -- Ciao, Billy +------------------------------------------------------------------------------+ | I used to be indecisive, but now I'm not so sure... | +------------------------------------------------------------------------------+