First of all this is not the way to store data. If you need 'House Number' from your table you have to store it as 'House Number'. Still, if you are unable to do that you will have to rely on finding the substring from your address field. Now, the problem is we will get the first index of ' ' and find the substring. But what if the address has preceding spaces? You will have to trim the blank spaces from the left of your string. I would recommend you to google 'SUBSTRING' and 'LTRIM' functions for SQL Server before moving ahead. Then only try this query for your understanding:
DECLARE @address VARCHAR(50) = ' 2508 Sample Address'
SELECT SUBSTRING(LTRIM(@address),1, CHARINDEX(' ', LTRIM(@address)))
Now, for your requirement, you should write:
SELECT SUBSTRING(LTRIM(employeeAddress),1, CHARINDEX(' ', LTRIM(employeeAddress))) AS [House Number] FROM [YourTableName]