Re: ORACLE function "TRANSLATE" in IDS 7.30

June Tong wrote: > > Volker Fraenkle wrote: > > > is there a functions like ORACLE TRANSLATE in INFORMIX 7.30? If not, is > > there a possibillity to cover this funktion via SPL? > > Maybe. If you described what it's supposed to do, we might be better able > to help. > > June > -- > june_t@hotmail.com > Lost in the wilds of Palo Alto, living on Plain M&M's SQL-92 defines TRANSLATE as a function to convert a source string from one character set or representation to another with the syntax TRANSLATE (source USING conversion). Does Oracle define it this way? I believe Informix supports only one language in NLS. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions AND the release notes. All opinions are my own and not those of Bayer plc. My Internet plumbing does not allow me to mail and post news together. Sorry. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/