General information
Category:
Coding, syntax & commands
Try this: DELETE FOR !("PLED" $ Field_a) AND !("CERTIFIED" $ Field_a)
>I am trying to delete a specific set of records that don't meet a particular criteria from my table. The code is as follows:
>
>DELETE FOR Field_a not LIKE '%PLED%' AND field_a NOT LIKE '%CERTIFIED%' IN DOWNLOAD_TABLE3
>
>and I get the following error message:
>
>command contains unrecognized phrase/keyword
>
>
>I am trying to delete all record that don't contain the word "CERTIFIED" OR 'PLED'. Is a problem using the operator LIKE? If so, is a another way of deleting records that don't match my criteria?
>Help appreciated.
>
>
>THanks
>Nick Patel
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only