TOTAL IN QUERY
I want to display total in query for each row like unit price + landed cost.Here unit price is always there but landed cost is applicable some times .So in some records it is blank.so in those case the total also appears as blank.
Pls let me know how to handle this.
murtaz is right.
u have to used isnull function.
select sum(isnull(b.quantity,0 )) from ibt1 b