Is there a way to have WHERE [column name] = all? 3

[MustangManny]

Is there a way to have WHERE [column name] = all?
If so what is the parameter?
The asterisk does not work there.

By default I wanted to have my query:
SELECT * From GALAXIES Where Category = [parameter], where parameter would be ALL as default.

Is this possible?

Thanks in advance.

 

[SQLSister]

NOt sure exactly what you mean. BUt I'm presuming you mean you want all possible catergyies to be found.

Do this in a stored procedure with a default value for the parameter of 'all'

Then use and if statement
If @Param1 = 'all'
SElect * from TAble1
Else
Select * from Table1 where Gatefory = @Param1

 

[Golom]

How 'bout

SELECT * From GALAXIES 
Where Category = [parameter]
      OR [Parameter] = 'ALL'

 

[MustangManny]

Thank you, I will have to try it on Monday when I get back to work.