Null value -- help - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Null value -- help

Author

Topic

thanksfor help
Posting Yak Master

106 Posts

Posted - 2007-08-02 : 15:03:18

Hi,

I have following situation

declare @a decimal(18,0)
declare @b decimal(18,0)
declare @c decimal(18,2)

set @a = 2
set @b = 2
set @c = 0

select case when ((@a - @b) > @c) then 0 end

In the case when @a and @b have the same value, I get the answer NULL and not 0.

Please advice what I am doing wrong here. I need to get the value 0.

Any help is very much appreciated.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-08-02 : 15:08:12

select case when ((@a - @b) >= @c) then 0 end

Tara Kizer
http://weblogs.sqlteam.com/tarad/

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-08-02 : 15:08:27

select case when ((@a - @b) > @c) then 0 else 0 end

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-08-02 : 15:08:42