Re: LIKE operator. How does it work?

> > 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: > > 'Hello ' > 'Hello world' > 'Message 1' > 'Message 2' > 'Informix Online ' > > When I use LIKE operator to retrieve strings with ended spaces > > SELECT C FROM T WHERE C LIKE '% '; Might I ask why you care about the spaces at the end of the word? > I'm having many trobles with Informix so I think that Oracle is better!!! Statements like the above are bound to win over the hearts and minds of the people you are asking help from. I'm sure that those of us switching to Oracle for the first time would have just as many troubles when we first started out. cheers j. ________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA jparker@boi.hp.com Currently on loan to PLD/PE ________________________________________________________________________ Outside of a dog a book is a man's best friend. Inside of a dog it's too dark to read. (Groucho Marx) ________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. ________________________________________________________________________