This forum is closed. Thank you for your contributions.

Sign in

Microsoft.com

Microsoft

Remove From My Forums

check datefield whether it is null

Question
0

Sign in to vote
hai,

how to check whether a date field is null in sql query,,when i check date field in a query using case ,"conversion from datefield to string is not valid" error comes,,,pls help

Elby
- Moved by Kiran Polimetla Wednesday, October 7, 2009 11:55 AM Not related to suggestions and feedback (From:Suggestions and Feedback for the Forums)
Wednesday, October 7, 2009 5:35 AM

Answers

0

Sign in to vote
Hello,

Thank you for your post! I would suggest creating a new thread for your question in the (SQL Server Developer Center > SQL Server Forums > Transact-SQL ) forum located here: (http://social.msdn.microsoft.com/Forums/en-US/transactsql/threads).

Hope that would be helpful.

Have a great day!

Thanks & regards,
Ashawani Tier 2 Application Support Server and Tools Online Engineering Live Services Team
- Proposed as answer by ashawani_dubey Friday, October 9, 2009 6:57 AM
- Marked as answer by ashawani_dubey Thursday, December 10, 2009 8:54 AM
Friday, October 9, 2009 6:56 AM