<div>
Hi toddpotter,<br />
<br />
This ought to do it:<br />
<br />
UPDATE YourTable<br />
SET YourColumn = '_'<br />
WHERE YourColumn IS NULL<br />
<br />
Regards,<br />
<br />
Patrick
</div>


Hi toddpotter,

This ought to do it:

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

Regards,

Patrick

<div>
Do I do this through Enterprise Manager?
</div>


<div>
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.
</div>


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.

<div>
Sorry - here is the link<br />
<br />
<a href="http://www.aspfaq.com/show.asp?id=2455" rel="ugc">http://www.aspfaq.com/show.asp?id=2455</a>
</div>


Sorry - here is the link

http://www.aspfaq.com/show.asp?id=2455 [http://www.aspfaq.com/show.asp?id=2455]

<div>
toddpotter,<br />
<br />
With no disrespect intended toward ptjcb, why didn't you select my answer?<br />
<br />
Patrick
</div>


toddpotter,

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

Patrick

<div>
Honestly, I thought that I did but I selected ptjcb's reply by mistake.<br />
<br />
toddpotter
</div>


Honestly, I thought that I did but I selected ptjcb's reply by mistake.

toddpotter

<div>
Thank you, Nata.<br />
<br />
Regards,<br />
<br />
Patrick
</div>


<div>
<div class="content wysiwyg-content">
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 &quot;_&quot;. &nbsp;Can someone direct me how to accomplish this. &nbsp;I even need the basics like &quot;create a stored procedure...&quot; or &quot;add a user defined function..&quot; &nbsp;Besides creating tables and viewing tables I know very little about SQL. &nbsp;Thanks.
</div>
</div>


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.

SQL Server Update/Replace Command

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.