I am trying to use a case statement in my where clause to do a datediff so that when my close_date is null it will use getdate() instead of the close_date column. With the code poste below I receive the following error: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near '>'. SELECT ...
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
cgreene.gsu
on
07-18-2008, 12:00 AM
Filed under: "ASP.NET and SQL Server", "Dynamic SQL", "T-SQL", case datetime, Data, date sql, DATEDIFF NULL, datediff sql sql2000 sql2005, getdate() SQL Server 2005, null, null value column, Select * from tablename where column1 = (), where, slq 2005, DB NULL, SQL, SQL Server 2005, "SQL Server", .NET SQL Server 2005