I want to select records where a column is null, is not null or is equal to a specific number. How do I do this in one sql statement. My application is an asp.net web site with a business logic layer, a data access layer and sql server. Thank you in advance.select *
from tb
where isnull(col,'*')=isnull(@.search,'*')
Showing posts with label equal. Show all posts
Showing posts with label equal. Show all posts
Subscribe to:
Posts (Atom)