Re: does nvl function work with characters?

Yes, the NVL does work with character types. It sounds like you are using a number type in your NVL statement. This will not work b/c the value type you return must be the same type as the field you are testing. In your case you can not return a char type to a number type.

Hope this helps

-jeff-

deb wrote in message ...
>hi,
>just wanted to know if nvl function can work with characters.....because i
>tried to substitute null values with the word 'not available' but it didnot
>work.it replaces the null value with '0' but doesnot insert characters.
>
>
>
>
Received on Mon Apr 19 1999 - 18:32:48 CDT