Finding Numbers

[Rozza]

Hi, I have a customer table which stores customer info such as name, address, etc. The data is taken from a till system and for some unknown reason there is a field full of numbers contained within the address data, there are no letters in the field only numbers. There are a total of 7 address fields, the "number" field can occur at different positions for each address, it doesn't always occur at say field 7. What I need to be able to do is find all those records with the string of numbers in the address data as it is breaking my address cleaning software. Can anyone help me to identify records that contain only numbers in a field?

Best Regards

Paul Rowling

 

[DrSimon]

Use the function isnumeric()
Simon Rouse

 

[Rozza]

Thanks Simon, works well!!