Re: LIKE operator. How does it work?

I'm not sure why your select doesn't work, maybe it has something to do with converting a varchar to a char in the select, but this does work (for varchars): select c from t where length(c)+1 != length(c||"|") -- Sincerly, Doug Wilson(dougw@amgen.com) *** The opinions expressed here are my own and not neccessarily *** *** that of a rational human being . . . ************* Giuliano Ferraro wrote: > > 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'm having many trobles with Informix so I think that Oracle is better!!! Luckily I am not familiar with Oracle so I will not comment, but I'm sure others will. > > Thank you in advance. *** Disclaimer: These are the opinions of the poster not Amgen Inc.***