I have some data in a table called Addresses:

```
HouseNumber Address
32          32 The Street
1           2 The Way
4           4 The Street
5           5 The Street

```

I am trying to find the House Numbers that are incorrect.  

I thought the query below would return '2 The Way' but it does not.

```
select Address
FROM   Addresses
WHERE  HouseNumber NOT LIKE '%' + Address + '%'

```

Is there any easy way to do this like in the query above, or do I have to write a stored procedure?