SQL - Extract Street Number from Address. See Description for SQL code.

#query #sql #data

Query:

Select
substr(address,1,instr(address,' ')-1)
As street_number
from employees;

Tool:
SQL Play