How to Check a String to See if the Value Is Numeric in SQLIn Feburary 2016 24,

In Feburary 2016 24,
Run your database, and open your usual textual SQL query generator.
Write a query that includes the value you want to check. Using SQL, you can check a field's value by using a regular expression. For example,SELECT DISTINCT my_data FROM my_tableWHERE my_data REGEXP ('[0-9]');Substitute the value 'my_data' with your field name and 'my_table' with your table name. Construct your query using the above as an example of how to determine whether a field is numeric or not.
Execute your query on some test data first. Check that the output matches what you expect to happen before using the query on live data.
In Feburary 2016 24,