default value in the view?

[summiyashaheen]

i have a table of purchase having bill field, another table of payments is linked with purchaseid as foreign key from purchase table. how may i have "0" instead of null in a view for the purchases for which no payment is made????????

[hariharanmca]

i have a table of purchase having bill field, another table of payments is linked with purchaseid as foreign key from purchase table. how may i have "0" instead of null in a view for the purchases for which no payment is made????????

What is the version of Database

Sql Server or MS Access.

[summiyashaheen]

sql sever. can i use isnull() in expressions to calculate outstanding amount of every purchase?

[hariharanmca]

sql sever. can i use isnull() in expressions to calculate outstanding amount of every purchase?

Yes you can use isNull like

[CODE=sql]isNull(fieldNam e, Defaultvalue)[/CODE]