General information
Forum:
Microsoft SQL Server
WHERE mydatefield = @dateparm OR mydatefield is null
Why doesn't that work?
>Hi,
>
>assume: mytable.mydatefield - mydatefield can be null
>
>Is there any way that I can write in ONE where clause a statement to find all records in mytable where mydatefield 'equals' a passed in parameter, and that parameter can either be a date value or null?
>
>currently - I have to test to see if the parameter is null or not and either run "where mydatefield = @dateparm" or "where mydatefield IS null". This requires either two different statements or dynamic SQL - and since the real query is much longer and inside a case statement, ... well - you get the point ....
>
>Life would be SO MUCH EASIER if T-SQL simply understood "where mydatefield = @dateparm" and @dateparm could be null and would return all recs where the datefield was null.
>
>Any help much appreciated.
>
>TIA!
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only