hai

i am trying to subtract two column max and min.
The problem is that the max column can contains null values. when i try to subtract these two columns it returns null values if max value is null. how can i handle this i want to show the value if min is not null.

regards


vamsi

__________________
vamsi Krishna G
mobile: 91 + 9986023966.
124 Puttappa layout new Tippasandhra,
bangalore.
Inida

Look into using the ISNULL function and put the subtraction in an IF statement. Something like:

IF ISNULL(maxvalue, 0) <> 0
BEGIN
  --Do subtration
END
ELSE
BEGIN
  --do something else...

There is probably also a better way to do this but this is just off the top of my head. Hope it helps...

Scott

thanks for ur help. its working fine

vamsi