Return All if parameter is null

[ZmrAbdulla]

This must be covered earlier.. Please direct me if there is one.

I have a "view" like below.

SELECT     EmployeeName
FROM         tblEmployees
WHERE     (EmployeeName LIKE '%' + @EmployeeName + '%')ORDER BY EmployeeName

The Parmeter is taken from an asp.net page textbox. If nothing entered into the textbox then I need to return all data. How it can be done?

thanks


Return All if parameter is null

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[gmmastros]

SELECT EmployeeName
FROM   tblEmployees
WHERE  [!](@EmployeeName Is Null)
       Or [/!](EmployeeName LIKE '%' + @EmployeeName + '%')
ORDER BY EmployeeName

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[ZmrAbdulla]

Brilliant!
thanks Master!

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.