Home Forums SQL Server 2008 SQL Server 2008 - General need where clause with date is blank RE: need where clause with date is blank

  • August 8, 2014 at 3:12 am

    #1736333

    zafar.majid (8/8/2014)

    trying to get query where date is blank. can anyone help me?

    Which data type does date have? Because a blank date with an actual date data type does not exist (the empty string gets converted to a default date).

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP