SQL function ?

[danial]

Help me please
How can I create Query Pass Through(SQL Server Transact-SQL)
with formula value1 + value2
when some record of value2 is null value
I'm try to use (Value1 + Value2) as TotalInc
example : Value1 = 500, Value2 = ""
return value in TotalInc = ""

I need it show 500

Tnk inadvance

(in a normal access use function nz() )

 

[CT Witter]

Try the following

ISNULL ( a1, a2 )
where a1 is the expression to be checked for NULL and a2 is the expression to be returned if a1 is NULL. If a1 is not null then a1 is returned.

HTH,
CT

 

[danial]

got ya
thank a lot.
isnull(value1,0) + isnull(value2,0)