Access SQL Query to Delete records based on Condition
Posted on 2015-02-24
I have a table that needs to be dedicated to just one customer. However, the records do not have the customer names listed like I would like. I need to delete some records based on a condition that is one of the fields.
Table Name: DSCNSKPIUPDATE
Field Name: Reject
So In my field "Reject" I have several different formats of text. However, I only want to keep the records that start with "R0".
** The records have back up copies for the other customers **
The text look like these...
To be released
As you can see there are many different formats. I need to remove all records that do not start with "R0".