Hallo,
I have a table with more than 10.000 records. Each record is a product en has a product number which contains letters and numbers. Ex F110NB or 190B. Some letters are referring to a model some to a color. The letters and the numbers differ in every record and sometimes there are 6 characters, sometimes 4, 9 or 10. I would like a query which returns only the numbers.
I have a table with more than 10.000 records. Each record is a product en has a product number which contains letters and numbers. Ex F110NB or 190B. Some letters are referring to a model some to a color. The letters and the numbers differ in every record and sometimes there are 6 characters, sometimes 4, 9 or 10. I would like a query which returns only the numbers.