> 
> I want to select all column values irrespective of NULL as column value
> 
> 
> 

my problem is when i try to select values using IS NULL i'm getting such records also thise having NULL as a value :( 

```
declare @status varchar(50)=NULL
declare @path varchar(50)= 'India'

select 
*
from [vwMYDATA] 
where
Path like '%' + @path + '%' and
(Status = @status or @status IS NULL)

```

vwMYDATA

```
path    status
INDIA1  NULL  
INDIA2  close
INDIA3  open

```

If i execute above query i'm getting all records whose status column has NULL value

> 
> expected is if no status value specified show all status records
> 
> 
> 

```
path    status
INDIA1  NULL  
INDIA2  close
INDIA3  open

```

it is showing 

```
path    status
INDIA1  NULL  

```

I'm passing these 2 parameters to stored procedure which is having this select statment.

please help me to filtered out and show all the records if status is not given as input