RE:Manejo de valores Nulos
Saludos...
En el select puedes usar un if... endif...
SELECT campo1, campo2, IF campo3 is null then 0 endif from tabla...
Para que te explique mejor...
Using IF-THEN-ELSE in SELECTS
This is one of those amazing features I was talking about. Did you know that the following is a valid Watcom-SQL statement -
SELECT
emp_fname,
emp_lname,
IF status = 'A' THEN
'ACTIVE'
ELSE
'TERMINATED'
ENDIF emp_status
FROM employee
Or even this one, which emulates a CASE kind of construct -
SELECT
emp_fname,
emp_lname,
IF status = 'A' THEN
'ACTIVE'
ELSE IF status = 'L' THEN
'ON LEAVE'
ELSE
'TERMINATED'
ENDIF ENDIF emp_status
FROM employee
Nota... esto es en SQLAnywhere... no sé si funciona igual en ASE o inclusive en SQLServer (que es una BD derivada de los orígenes de ASE V. 4)
Espero que te sirva...