johnpienaar
Technical User
Hi
I am trying to filter a query to exclude any rows where the Identity Number field has any alphanumeric (not sure if this is the right word) values in it. eg:
i would want to exclude rows where the Identity Number field is '123fgh345' or 'sdf123456' only keeping rows where there are numbers only eg '123456789' the values are currently stored as varchar.
help would be greatly appreciated.
I am trying to filter a query to exclude any rows where the Identity Number field has any alphanumeric (not sure if this is the right word) values in it. eg:
i would want to exclude rows where the Identity Number field is '123fgh345' or 'sdf123456' only keeping rows where there are numbers only eg '123456789' the values are currently stored as varchar.
help would be greatly appreciated.