Re: Simple SQL statement

You want the NVL(Column, ReturnVal) Function:

Select NVL(YOUR_COLUMN, 'No Commission') From YOUR_TABLE

"cycloid1" <cycloid1_at_alltel.net> wrote in message news:8peo29$2da$1_at_iac5.navix.net...
> Hi all,
>
> I am in the beginning phases of learning the SQL language. I'm taking the
> intro to Oracle class and I've run into a snag. I'm trying to write a
 simple
> statement that will convert a null that exists in a column with a numeric
> datatype to a character string. In other words, if it encounters a null
> (numeric column) I need it to spit out "No Commission". Does the DECODE
> function allow you to convert from on datatype to another? I can't get
> TO_CHAR to work either. I'm sure it's a syntax thing. Thanks in advance
 for
> any help!
>
Received on Tue Sep 12 2000 - 12:52:20 CDT