 <p>You can split strings using the answer to this <a href="http://stackoverflow.com/q/314824/111013">Stack Overflow Question</a>. </p> <p>Having this function created, you can use it like so: </p> <pre><code>Declare @postcodes varchar(128) SET @postcodes = '2130 2602' SELECT * FROM users JOIN dbo.Split(' ',@postcodes) postcodes ON users.postcode = postcodes.s </code></pre>