I would like to write an sql query which returns only numeric values from the Emp_ID column that have the length of 6 numbers.
If the Emp_ID is shorter than 6 or it contains letters I don't want them to be returned.
Thanks for your help.
In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!