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
Condition: R0*
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...
R0117730
R0116926
R0118216
or
N/A
20140903436
2014070323
1
To be released
As you can see there are many different formats. I need to remove all records that do not start with "R0".
I'm assuming you are using this in access:-
Open in new window
Change the RO one in single quotes if you are working in SQL and remove * from the same...
Saurabh...