title: Filtering for only integer/numeric values in a varchar field
body: <p>I have a table with a member id column (non-PK) that should all be integers. But many are NULL or non-integer values with a mixture of letters, numbers, and other random characters (the field is of type varchar). I want to select only rows containing valid member id's (i.e. integers or only numeric values). I'm working in SQL Workbench. Thanks in advance!</p>