28 Dec
1999
28 Dec
'99
8:30 p.m.
Hello... I am sorry to repost this message, but I didn't receive any reply so I presume that, since I sent this email on Dec 25, it passed un-noticed ;-) I have an Oracle table where a field is a NUMBER .... I do a SELECT field FROM oratable and I get "2.29" ... (without quotes ;-) But when doing the same SELECT from a ZSQL I get "2" ... no decimals. I don't know if it's an Oracle specific problem... Anyone has a clue? I tryied using the TO_NUMBER(field, '9999.99') function but it returns "2"... TIA /B Bruno Mattarollo <brunomadv@ciudad.com.ar>