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

Question

For example

SELECT * FROM movies WHERE director=*

Answer 1

No, you would need to use the LIKE operator and the % wildcard:

SELECT * FROM movies WHERE director like '%';

Answer 2

You can use LIKE;

SELECT * FROM movies WHERE director LIKE '%' --all
SELECT * FROM movies WHERE director LIKE 'john landis' --exact
SELECT * FROM movies WHERE director LIKE 'steve%berg' --with wildcard