SQL Server Update/Replace Command

I am a very new user to SQL Sever and I am trying to change all of the NULL fields in a table to a "_".  Can someone direct me how to accomplish this.  I even need the basics like "create a stored procedure..." or "add a user defined function.."  Besides creating tables and viewing tables I know very little about SQL.  Thanks.
toddpotterAsked:
Who is Participating?
 
Patrick MatthewsCommented:
toddpotter,

Query Analyzer

Regards,

Patrick
0
 
Patrick MatthewsCommented:
Hi toddpotter,

This ought to do it:

UPDATE YourTable
SET YourColumn = '_'
WHERE YourColumn IS NULL

Regards,

Patrick
0
 
toddpotterAuthor Commented:
Do I do this through Enterprise Manager?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
ptjcbCommented:
toddpotter - you should avoid using Enterprise Manager to run queries. It is a good tool to manage databases, but it will sometimes fail to return results (time outs) or inconsistent results. To run queries, Query Analyzer is your friend. This link is a good example of the differences between the two tools.
0
 
ptjcbCommented:
Sorry - here is the link

http://www.aspfaq.com/show.asp?id=2455
0
 
Patrick MatthewsCommented:
toddpotter,

With no disrespect intended toward ptjcb, why didn't you select my answer?

Patrick
0
 
toddpotterAuthor Commented:
Honestly, I thought that I did but I selected ptjcb's reply by mistake.

toddpotter
0
 
Patrick MatthewsCommented:
Thank you, Nata.

Regards,

Patrick
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.