how to set 0 instead of Null in SQL
800340Jun 4 2006 — edited Jun 4 2006hi guys,
is there a way to have the return result as 0 not [NULL] when the return result is empty?
replace this
name relation
---------------------------
Dan 45
Mike [NULL]
Kopper 54
with this:
name relation
---------------------------
Dan 45
Mike 0
Kopper 54