you could put some sample records, entirre data is not required but based on what i have understood you can do something like this
If Isnull(@searchText,'')
select * from yourtable
Else
select * from yourtable
where isNull(Location1,Location2)=@searchText