<div>
Use the LIKE keyword with the any-set-of-characters wildcard &quot;%&quot;:<br />
<br />
SELECT *<br />
FROM TableA<br />
WHERE field1 LIKE '94%'<br />

</div>


Use the LIKE keyword with the any-set-of-characters wildcard "%":

SELECT *
FROM TableA
WHERE field1 LIKE '94%'


<div>
thanks jd, that selects the fields, I'm guessing.<br />
<br />
Question is, how do I make field 2 in that selection empty/blank?
</div>


thanks jd, that selects the fields, I'm guessing.

Question is, how do I make field 2 in that selection empty/blank?

<div>
That hit the spot more full on! &nbsp;Thanks Paul - don't worry, I'll be trying it out on my test/wrecker database first!
</div>


That hit the spot more full on!  Thanks Paul - don't worry, I'll be trying it out on my test/wrecker database first!

<div>
<div class="content wysiwyg-content">
Hi guys<br />
<br />
I'm not an SQL query guru by any means, so I'm asking here!<br />
<br />
I have an SQL based accounting application.<br />
<br />
In my stock records, some of the product records begin with 94xxx.<br />
<br />
I field in the same table has been filled in incorrectly for certain 94xxx records, and needs to be blanked out - i.e.be empty.<br />
<br />
Trouble is, there's around 4-500 records to go through, something I don't fancy doing by hand!<br />
<br />
What would be an SQL query which would search all records beginning with 94 (say, field 1), and delete the contents of field 2 if it contains anything?<br />
<br />
thanks in advance<br />
<br />
Sean
</div>
</div>


Hi guys

I'm not an SQL query guru by any means, so I'm asking here!

I have an SQL based accounting application.

In my stock records, some of the product records begin with 94xxx.

I field in the same table has been filled in incorrectly for certain 94xxx records, and needs to be blanked out - i.e.be empty.

Trouble is, there's around 4-500 records to go through, something I don't fancy doing by hand!

What would be an SQL query which would search all records beginning with 94 (say, field 1), and delete the contents of field 2 if it contains anything?

thanks in advance

Sean

conditional SQL query to blank out a field

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.