Stripping the streetname from the number 1

[Zargo]

Hi,

I hope this will be the last quesion for today. I have a table with streetnames and housenumbers. I want to update this column with only the streetname and put the housenumber in another column. The table which i have is look like:

TableA
street | supplement
My street 123 |
StreetABC 56 |


After the update the table needs to look like:

TableA
street | supplement
My street | 123
StreetABC | 56

Thanks for the last time...

 

[LKBrwnDBA]

Try this, but be aware if there is an 'apartment number' next to the street number (vg 'The Streetx 123 apt 45'), it will not work:

Select
       substr(street,1,instr(street,' ',-1)) as street
     , substr(street,instr(street,' ',-1)+1) as suplement
  From TableA;

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb