SQL omit record if ever had value set

I would like a query that lists records where a column has not taken
on a specific value when grouped by another column.

N  V
n1 v1
n1 v2
n2 v1
n2 v2
n2 v3
n3 v1

If v3 has ever been set for N, do not list N.  So the result would be n1, n3

If v2 has ever been set for N, do not list N.  So the result would be only n3

MSSQL

TIA

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php