if I execute, for example select sin(sin(52*sin(2)) from dual
I get NULL as result. It should be 0.78154461294988686. Next thing I tried: create table zzz (a float) insert into zzz select a=sin(sin(52) * sin(2)) from dual This one now fails with "General Error; -3024 POS(1) Invalid Numeric Expression" Very STRANGE: If I use an addition instead of the multiplication (a=sin(sin(52) + sin(2)) from dual) it works!! One more test: I tried with constants: select Sin(0.01745329251994 * 48.110) from dual Result: 0.744428093663393 - Correct I changed 48.110 to 48.111: select Sin(0.01745329251994 * 48.111) from dual Result: NULL This is very strange. Can you help me? _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
