Hi All,
In an Access table, I have a field called "CaseNote" the type of field is text.
This field meant to keep only Numeric values but some how I have found some values keep String values like "A", "M" or others , normally in starting used as prefix Example
M234343
But some time in middle of number like 323X324.
Is there any way I can using any SQL function to check how many rows keep Alpha values i.e. A to Z any postition in an string or find any value keep other values than Numeric.
The table keeps around 55K rows and I can check a single row or filter becaue each rows normally are different
Many thanks
Farhan
In an Access table, I have a field called "CaseNote" the type of field is text.
This field meant to keep only Numeric values but some how I have found some values keep String values like "A", "M" or others , normally in starting used as prefix Example
M234343
But some time in middle of number like 323X324.
Is there any way I can using any SQL function to check how many rows keep Alpha values i.e. A to Z any postition in an string or find any value keep other values than Numeric.
The table keeps around 55K rows and I can check a single row or filter becaue each rows normally are different
Many thanks
Farhan
Last edited:
