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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

removing nulls

Status
Not open for further replies.
sthmpsn1

sthmpsn1

MIS
Sep 26, 2001
456
US
Is there anyway to go through a table with an sql statement and replace any null values with a space " "?
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

briangriffin
  • Locked
  • Question
Performance Issue When Filtering on Nulls 3
Replies
5
Views
201
sqlprogrammers
sqlprogrammers
lesleycampbell
  • Locked
  • Question
Inserting text into field without removing existing data 2
Replies
8
Views
543
Olaf Doschke
Olaf Doschke
HoustonGuy
  • Locked
  • Question
Removing Nulls and Reordering sequentially 2
Replies
6
Views
173
drlex
drlex
GhostWolf
  • Locked
  • Question
Removing Deleted Rows?
Replies
8
Views
253
Olaf Doschke
Olaf Doschke
ronaldmacdonald
  • Locked
  • Question
Removing duplicate values from a table 1
Replies
2
Views
111
ronaldmacdonald
ronaldmacdonald

Part and Inventory Search

Sponsor

Back
Top