URGENT: Undocumented functions in isql

> does anybody have a list of undocumented features in isql??? > I only know the function "trunc" and i recognize that someone > wrote here a SELECT-statement with a concat-function a few > days ago. > > Thanks, Stefan [...long .sig deleted...] Documented undocumented features? Isn't that a contradiction somehow? Anyway, I shamelessly stole this from the November 1994 edition of the FAQ: 4.1.6.3 Undocumented math functions from SELECT SELECT ACOS(col1), ASIN(col1), ATAN(col1), ATAN2(col1,col2), COS(col1), HEX(col1), LOG10(col1), LOGN(col1), ROUND(col1), SIN(col1), SQRT(col1), TAN(col1), TRUNC(col1) FROM foo_table; (thanks, Kerry) There may be more, but *don't* RTFM! __________________________________________________________________ | Clem Akins Standard Disclaimers Apply | |Reynolds Metals Co, Alloys Plant "Climb High, Cave Deep!" | | Muscle Shoals, Alabama USA cwakins@leia.alloys.rmc.com | |________________________________________________________________|