manjithota
New User
Joined: 09 Jun 2005 Posts: 10
|
|
|
|
hi all,
in the VALUE function we can put multiple values which are to be substituted in case our first argument is a null. this is quite clear that, in case we have specified only one default value then that will be substituted at a null occurence. but what happens when multiple values are given there ? could somebody help ? |
|
Ravi Gopal
New User
Joined: 04 Aug 2005 Posts: 3
|
|
|
|
Hi,
The VALUE function will substitute the first value that you are passing to the null column.
It wont give any error ,if you pass multiple values.But it ignores the second value.
SELECT CODE,VALUE(ST_DATE,'0001-01-01','0002-02-02')
FROM ABC.TRUST
This query ignores the second value '0002-02-02' while execting.
Regards
Ravi |
|