Hello one more time, we have resolved our first problems with dates after migration from Oracle. Now we have SQL the use the Oracle function nvl(field,'nothing') to set the second parameter to field if it is null.
Example: select a ,NVL(b, 'nothing') as B from testdb5 If we use this sentence in SQL Studio (Oracle Mode) we get "General error;-3065 POS(19) Invalid date input value." Thanks, Ignacio _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
