Home Forums SQL Server 7,2000 T-SQL WHERE clause using specified parameter value or "ALL" or NULL values RE: WHERE clause using specified parameter value or "ALL" or NULL values

  • September 16, 2004 at 3:36 am

    #523282

    An example using Northwind:

    declare @LastName nvarchar(20)

    set @LastName = 'All'

    select *

    from Employees

    where LastName = isnull(nullif(@LastName,'All'),LastName)