no nulls in query... 1

[adsfx]

have sql-

SELECT tbl_equipment.equipID, tbl_equipment.equippctcp
FROM tbl_equipment
ORDER BY tbl_equipment.equippctcp;

how do i make not display nulls?

cheers MG

 

[r937]

display blanks instead

SELECT IIF(ISNULL(equipID),' ',equipID) as ID
, IIF(ISNULL(equippctcp),' ',equippctcp) as ctcp
FROM tbl_equipment
ORDER
BY equippctcp

or else drop any row from the output that has a null

SELECT equipID
, equippctcp
FROM tbl_equipment
WHERE equipid IS NOT NULL
and equippctcp IS NOT NULL
ORDER
BY equippctcp


rudy

 

[adsfx]

r937- brilliant wish i could write sql with style...am learning