 |
|
Windows Web Hosting 30 Day Free TrialWindows Hosting 30 Day Free Trial, with no obligation, on all our Windows Web and Reseller Hosting Packages.For more information see our Windows Hosting 30 Day Free Trial page. |
Replace Null values with mytext in SQL |
Post Reply 
|
| Author | |
farrukh 
Groupie 
Joined: 10 May 2002 Location: Pakistan Status: Offline Points: 147 |
 Post Options
 Thanks(0)
 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 Points: 386 |
Post Options
Thanks(0)
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)); |
|
|
|
Topic Options|
Post Reply
|
|
Tweet
|
| 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 |
