You should add the printer to your local

I haven't heard of SQL Server 2008:confused:

of cause, the code like this: Select case when sum(sal) is null then 0 esle sum(sal) end from table1 where empid=1 and date>'1/23/2006' :laugh: