Search empty string, Single quotes,double quotes and null
We have a custom search in our application. When we search for say first name ="" (double quotes) it returns all the values. When we search for the same field with '' (single quotes), it says no results found. And when enter NULL in the text box it return No Results found.
Why is this behavior different?
***Updated by moderator: Lochan to update Categories***