0

I am trying to create a column with the numbers that are part of a string for the entire column.

For example the column containing the empid like

  1. A12SD9
  2. A12SA1
  3. A10AA1

I have seen examples for a single string but I would like to apply it to the full column.

Joaquim
  • 57
  • 1
  • 4
  • Make it more brief, your question is not clear – Pratik Karmakar Mar 28 '18 at 09:12
  • Hi Pratik thak you for your prompt replay. What I am trying to do is to extract the numbers from a column so in the example I gave it would be for the first row 129 for the second 121 and 101 to the third . Thank you – Joaquim Mar 28 '18 at 09:25
  • @Joaquim is the format of value will remain same i.e. only 2nd,3rd and 6th character would be number always? anyway this will help you in either case - https://stackoverflow.com/questions/16667251/query-to-get-only-numbers-from-a-string & http://www.sqlfiddle.com/#!18/0b383/36 – Sachin Mar 29 '18 at 12:23
  • Which [DBMS](https://en.wikipedia.org/wiki/DBMS) are you using? "SQL" is just a query language, not the name of a specific database product. Please add a tag for the database product you are using `postgresql`, `oracle`, `sql-server`, `db2`, ... –  Mar 29 '18 at 12:30

0 Answers0