Search parameters

[dhabi]

MS SQL only, please.
Need a WHERE term that will return all the rows in the table thus:

Select * FROM Business
WHERE BusinessName =

What, placed after the equal sign, will return every row in the table? Spent all afternoon trying to figure this one out and haven't found it yet. This is the one needed to use the multiple search parameters.

Thanks in advance

[MAK]

Select * FROM Business
WHERE BusinessName = BusinessName

[skhanal]

Don't use WHERE clause and it will return all rows

Select * FROM Business

if it must be used then any true condition can be used

Select * FROM Business
WHERE 1=1