Hm, can you show me how to get this running?
declare @open bit
set @open = 0
SELECT * FROM orders
WHERE
shippeddate
CASE @Open
WHEN 0 THEN
Is Null
ELSE
IS NOT NULL
END
Server: Nachr.-Nr. 156, Schweregrad 15, Status 1, Zeile 6
Falsche Syntax in der Nähe des CASE-Schlüsselwortes.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]