Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Appending Null Values

Status
Not open for further replies.
SILLEYJ

SILLEYJ

MIS
Jan 25, 2000
43
GB
I have a table with 1800 records I would like to append all of the Null values to be a ZERO rather than null. How would I write the query to update all the fields??

Thanks
Jeff
 
Status
Not open for further replies.

Similar threads

btamsgn
  • Locked
  • Question
How to arrange the values in column heading based on column STT
Replies
10
Views
2K
combo
combo
SoLost1
  • Locked
  • Question
Please Help for Passing Multiple Select ListBox Values as Parameter for WHERE IN clause of Query
Replies
3
Views
428
dhookom
dhookom
teach314
  • Locked
  • Question
Finding records that have no values in common 1
Replies
2
Views
232
teach314
teach314
03Explorer
  • Locked
  • Question
make a field within a query to increment values for purpose of output only 1
Replies
11
Views
451
03Explorer
03Explorer
teach314
  • Locked
  • Question
Filling a column with 'missing' values 1
Replies
5
Views
251
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top