Hi Janine,
If you're using oracle, there's a great way around this (and I'd assume sql
server has something similar). Use the nvl function in your query like so:
SELECTnvl(columnname, 0)
FROM yourtable.
nvl basically replaces nulls with something else. The only caveat is that
the replac
I have set up an excel sheet to show results of a search. I also want to
add another search- when the field is null or X. The query works, however,
it does not show up correctly on the excel sheet.
1. The excel sheet does not line the nulls under the correct headings. No
matter where on the sheet
2 matches
Mail list logo