Обсуждение: check for null value

Поиск
Список
Период
Сортировка

check for null value

От
Ashok Chauhan
Дата:
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

От
"scott.marlowe"
Дата:
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.