RE: NVL function

 jain cj  wrote:

> 
> Hi,
> 
>   How to use NVL(Oracle) function in sapdb.
> 
> eg: select nvl(fieldname,'result') from test.
> 
> if the fieldname is null it will give 'result'

see the mail to Jens haf an hour ago:

two chances:
1. use SQLMODE Oracle and NVL
2. use SQLMODE internal (the default) and VALUE-function

Elke
SAP Labs Berlin