Urgent: Sounds like
This is a multi-part message in MIME format. --------------0EFD4D92CC4B2A1EBB557DAF Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi Gurus, I have a query. What is the counterpart of SOUNDEX() in Informix. Were using Informix-SQL 7.20 UE1 and Informix-4GL 7.20 UE1 Thanks for the help. Regards, Jojo --------------0EFD4D92CC4B2A1EBB557DAF Content-Type: text/x-vcard; charset=us-ascii; name="ejmorale.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Jojo Morales Content-Disposition: attachment; filename="ejmorale.vcf" begin:vcard n:Morales;Jojo tel;work:830-58-40/42 x-mozilla-html:FALSE org:DHL Aviation Phils.;APME-OPS IT Development version:2.1 email;internet:ejmorale@apme-ops.dhl.com title:IT Contractual Developer note:/* These are my opinions, not my company's opinion */ adr;quoted-printable:;;12/F Urban Bank Plaza=0D=0APasong Tamo cor. Buendia;Makati;;;Phils. fn:Jojo Morales end:vcard --------------0EFD4D92CC4B2A1EBB557DAF--
there is an example of creating a udr based on a soundex algorithm on the informix web site. if i remember it was a simple version, but you could create your own. you would have to have the 9.x IDS series to implement it. Eduardo MORALES wrote: > This is a multi-part message in MIME format. > --------------0EFD4D92CC4B2A1EBB557DAF > Content-Type: text/plain; charset=us-ascii > Content-Transfer-Encoding: 7bit > > Hi Gurus, > > I have a query. What is the counterpart of SOUNDEX() in Informix. > Were using Informix-SQL 7.20 UE1 and Informix-4GL 7.20 UE1 > > Thanks for the help. > > Regards, > Jojo > > --------------0EFD4D92CC4B2A1EBB557DAF > Content-Type: text/x-vcard; charset=us-ascii; > name="ejmorale.vcf" > Content-Transfer-Encoding: 7bit > Content-Description: Card for Jojo Morales > Content-Disposition: attachment; > filename="ejmorale.vcf" > > begin:vcard > n:Morales;Jojo > tel;work:830-58-40/42 > x-mozilla-html:FALSE > org:DHL Aviation Phils.;APME-OPS IT Development > version:2.1 > email;internet:ejmorale@apme-ops.dhl.com > title:IT Contractual Developer > note:/* These are my opinions, not my company's opinion */ > adr;quoted-printable:;;12/F Urban Bank Plaza=0D=0APasong Tamo cor. Buendia;Makati;;;Phils. > fn:Jojo Morales > end:vcard > > --------------0EFD4D92CC4B2A1EBB557DAF--