Deleting Only numerical data in a text field

[Kozbot]

Hello

I have a field that is text format. However many of the records in that field contain numbers.

I want to delete all the records that are numbers in this text field, leaving only records with textual data.

is this easily possible?

Thank you

 

[pr2-eugin]

You can use the IsNumeric function to test if they are Numbers.. Then use that as the Criteria for deletion..

 

[Kozbot]

You can use the IsNumeric function to test if they are Numbers.. Then use that as the Criteria for deletion..

SO I would put the function into the criteria and set it equal to false?

I'm trying to construct the query but its not working. The update query will not allow me to use the function in the field name

 

[pr2-eugin]

DELETE * FROM yourTableName 
WHERE IsNumeric(theFieldYouAreDoubtful) = True;

 

[Kozbot]

DELETE * FROM yourTableName 
WHERE IsNumeric(theFieldYouAreDoubtful) = True;

Ahh, but this will delete the ENTIRE record, correct?

I want to leave the record, but delete only the fields with numerical data. Sorry for not being more clear