SQL code to remove content from a field in DB needed
Can someone provide me with a SQL statement to remove content from 1 field in my DB.
I have a table called SHOP and withing that table I have Project field.
So this "Project" field should have no data at all, but some of our emp. but the letter "H" in it and how I cannot delete it.
So I want field "Project" to be " " instead of having "H" in it.
The above checks if project has anything it will be changed.
You can run the update query without a where clause and it will update every project column in every row.
Note " " is not nothing it is a space. Nothing is "" i.e. empty set.