T-SQL 2008- Exit when Value is NULL
<p>I am looking for a way to exit an T-SQL script when @Value is null. This is what I have so far but it does not work as expected:</p>

<pre><code>SELECT 
    @Value,
    CASE 
       WHEN @Value IS NULL   
          RAISERROR('EXIT', 16, 1) 
FROM 
    table 
WHERE 
    name LIKE 'test'
</code></pre>