conditional SQL query to blank out a field
Posted on 2004-09-23
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