|
View previous topic :: View next topic
|
| Author |
Message |
deesun
New User
Joined: 29 Aug 2006
Posts: 15
|
|
|
|
| Can anyone please let me know how to remove teh columns with null values |
|
| Back to top |
|
 |
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Hi There,
I have not understood ur query clearly but i think u want to get all the rows where coloum1 is not null
Query
| Code: |
SELECT *
FROM table1
WHERE col1 IS NOT NULL; |
Please let us know if you want any thing other than this? |
|
| Back to top |
|
|
deesun
New User
Joined: 29 Aug 2006
Posts: 15
|
|
|
|
I have got what i wanted Thanks actually I wanted to do something like below remove the null values
EXEC SQL
UPDATE EMPLOYEE
SET PHONENO='NONUM' WHERE PHONENO IS NULL;
END;
EXEC SQL CLOSE UPCUR; |
|
| Back to top |
|
|
|
|
