danial
Board Regular
- Joined
- Apr 29, 2006
- Messages
- 107
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() )
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() )