Re: LIKE operator. How does it work?

Giuliano Ferraro wrote: > > Hi, > I'm porting an application from Oracle to Informix. I've this kind > of trouble. In a table T with a VARCHAR column C, there are some > strings with ended space. For example, in the C column of the > table T, there are the following strings: (snip) > > When I use LIKE operator to retrieve strings with ended spaces > > SELECT C FROM T WHERE C LIKE '% '; I think I'd call it a bug. Call Informix and report it as such. Good Luck. -- 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.***