Undocumented functions (was sqrt)

Sometime ago Graeme Sargent posted the following message to the net which answers some of the current questions on this thread. Hope it helps Regards Peter -- Peter K. Botcherby e-mail : p.botcherby@umds.ac.uk Paediatric Research Unit Guys Hospital, London, UK. ----- Begin Included Message ----- From ilist@rmy.emory.edu Sat Oct 9 15:20:47 1993 Return-Path: ilist@rmy.emory.edu From: graeme@pyramid-technology.co.uk (Graeme Sargent) Subject: FYI: Undocumented SQL functions in 5.00 Date: Fri, 8 Oct 1993 18:07:42 GMT Reply-To: graeme@pyramid-technology.co.uk (Graeme Sargent) Organization: Pyramid Technology Ltd. Original-Sender: informix-list-owner@edu.emory.rmy To: informix-list@rmy.emory.edu In <hashmiCEI2Lv.Bq@netcom.com> hashmi@netcom.com (Atiq Hashmi) writes: >1) Can we tell informix to compare but ignore if the values are >incompatible .? >OR >2) Before comparing T with P, tell informix to use(or cast) T's field >as char string. and later recast back? Which sent me looking for undocumented SQL functions in 5.00. I didn't find any equivalents to Oracle's TO_CHAR and TO_NUMBER functions as I had hoped, but I did find that: SELECT ACOS(col1), ASIN(col1), ATAN(col1), ATAN2(col1,col2), COS(col1), LOG10(col1), LOGN(col1), SIN(col1), SQRT(col1), TAN(col1) FROM foo; works very nicely thank you! Can't see much use for them myself (except maybe sqrt()), but I thought that someone might find it useful to know! graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.