"Kancha ." <kancha2np(at)yahoo(dot)com> wrote:
> Hello
>
> i want to run a select query on a table. eg:
>
> select age from people;
>
> if age is NULL then I want to replace it by some text,
> say "SHY" so the output is like
>
> name age
> me 10
> jane SHY
> jack 32
>
> how do i make this replacement of null value to some text
UPDATE people
SET age = 'SHY'
WHERE age IS NULL;
I hope that the field age is a text field;
Ciao
Gaetano
--
#exclude <windows>
#include <CSRSS>
printf("\t\t\b\b\b\b\b\b");.
printf("\t\t\b\b\b\b\b\b");