 |
|
 |
Replace Null values with mytext in SQL |
Post Reply 
|
| Author |
 Share Topic Printable Version Google Delicious Digg StumbleUpon Windows Live Yahoo Bookmarks reddit Facebook MySpace Newsvine Furl Topic Search  Topic Options
|
farrukh 
Groupie 
Joined: 10 May 2002 Location: Pakistan Status: Offline Posts: 152 Points: 152 |
 Post Options
 Quote Reply
 Topic: Replace Null values with mytext in SQLPosted: 07 April 2005 at 3:28am |
|
how can i replace null values with my own text in sql queries. i know the set null "mytext" sql plus command but i dont know how to do this in sql query during selection rows in table.. ne1 help me.. how to replace null values in a table by mytext in sql query |
|
|
i have collected some nice avatars (37) and smileys (227) here you can download
http://www24.brinkster.com/webmastertool/download.html |
|
 |
|
|
Phat
Senior Member 
Joined: 23 February 2003 Status: Offline Posts: 387 Points: 387 |
Post Options
Quote Reply
Posted: 07 April 2005 at 4:46am |
|
not sure what you mean but this will update every field in real name that has a null value
UPDATE tblAuthor SET tblAuthor.Real_name = "mytext" WHERE (((tblAuthor.Real_name) Is Null)); |
|
|
|
|
Post Reply
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
All prices are shown excluding VAT, which is charged where applicable. $, € prices shown as a guideline only.