Can you use an asterisk (*) to filter a column in a WHERE clause under SQL Server 2008?

SELECT * FROM movies WHERE director=*

select sql-server-2008 sql-server sql