Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I scan my database for null values
Message
From
26/10/2001 10:40:38
Ian Wilson
Stayinfront
Uxbridge, United Kingdom
 
 
To
25/10/2001 04:27:59
Hans Vangansbeke
Maxitoys
Marke, Belgium
General information
Forum:
Microsoft SQL Server
Category:
Database management
Title:
Re: How do I scan my database for null values
Miscellaneous
Thread ID:
00573060
Message ID:
00573641
Views:
19
Hi Hans,

For a quick and cheap solution, you could do something like:-

UPDATE [TableName] SET
[fieldname1] = CASE WHEN [fieldname1] IS NULL THEN 0 ELSE [fieldname1] END,
[fieldname2] = CASE WHEN [fieldname2] IS NULL THEN '' ELSE [fieldname1] END

Regards

Ian.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform