Re: String manipulation

Ronnie Diaz wrote: > > This is going to any informix wizards out there. > > I understand that when you use MATCHES for a select query, you can do > something like [Ff] to choose > between two different characters. Is there a way where you can do the > same thing with a string... for example > "I have your [(blue)(yellow)(green)] [(automobile)(car)]" would MATCH "I > have your yellow automobile" or "I have your green car", but not "I have > your purple car"? > > I'm trying to do this in server-side javascript and java, and the only > thing I can think of is creating some loop, but that would mean LOTS of > querying. > > I would really appreciate any help. I don't think there's a way to do that with the normal database servers. You could undoubtedly do it with some sort of datablade in IUS (IDS/UDO) -- possibly one of the standard text search ones or definitely with one of your own devising. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>