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

Question

for example

SELECT * FROM movies WHERE director=* 

Answer 1

No, you will 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 

Answer 3

 WHERE director like '%' 

this is the syntax

Answer 4

For this you need to use LIKE and wildcards:

 select * from movies where director like '%' 

Answer 5

If you are looking for results with ANY director, you can simply leave the WHERE director= completely.

If you want to do a partial match, you can do a WHERE director like '%Lucas%' , which will return the equivalent of *LUCAS* .

Answer 6

If you are looking for the director represented by * , you will have to enclose it between single quotes:

 SELECT * FROM movies WHERE director='*' 

If you are looking for any director, just leave where .

Answer 7

 select * from movies where director like '%' 

This will NOT return every row: rows with the null directive will be omitted (at least with MSSQL).