Re: Fuzzy Searches

Teresa Hutt wrote: > > Does anyone know how to perform fuzzy searches on an Dynamic Server 7.2 > database? We attempted to upgrade to Universal Server so that we could use > the text datablade, but there seems to be a bug in Universal Server that > causes the system to hang several times a day, so we were forced to go back > to 7.2. > > Are there any 3rd party tools out there that will add this functionality? > > TIA SELECT * from mytable WHERE 1=1 This is maximum fuzziness. How fuzzy do you want to be? Is it text you are searching? -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk --- My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/