Thread: check for null value

check for null value

From

Ashok Chauhan

Date:

16 January 2004, 10:49:22

hello

i am selecting ten fields form a table and i want to replace the null
values with any other value.

plz. help me

Ashok

Re: check for null value

From

"scott.marlowe"

Date:

16 January 2004, 13:38:20

On 16 Jan 2004, Ashok Chauhan wrote:

>
> hello
>
> i am selecting ten fields form a table and i want to replace the null
> values with any other value.

Look up coalesce(), it should do exactly what you need.