Delete Numbers Only

P

Petra

In the query view, what expression would I enter to delete out only numbers
within a comments column? Any help is appreciated. P
 
S

Steve Schapel

Petra,

This might work for you...
Like "#*"

Another idea would be to make a calculated field in the query, like this...
Val([Comments])
.... and then put the criteria in this column:
 
Top