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

Convert Zero Value to Null?

Status
Not open for further replies.
tombi5150

tombi5150

Computer
Joined
Mar 31, 2005
Messages
1
Location
US
Anyone know of an SQL function which converts a Zero value to a null?

Thanks
 
Sort by date Sort by votes
update <table name> set <field>=null where <field>=0
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

alainmarion85
  • Locked
  • Question Question
How to restore database MSSQL 2005 SP4?
Replies
2
Views
1K
alainmarion85
alainmarion85
genomon
  • Locked
  • Question Question
Counting different valuesin one column
Replies
0
Views
729
genomon
genomon
SteveMeisel
  • Locked
  • Question Question
Counting of differant values in one column
Replies
0
Views
720
SteveMeisel
SteveMeisel
nessty
  • Locked
  • Question Question
How to resolve SQLDiag issue
Replies
3
Views
943
genomon
genomon
NTrade
  • Locked
  • Question Question
sql to create value dependent on prior record
Replies
1
Views
775
rtmpxr
rtmpxr

Part and Inventory Search

Sponsor

Back
Top