Macgyver7 <t...@buffaloriverforge.com> wrote: > Thanks Igor, that works, however there is a problem. This will only return a > result when there are no null fields in the last two columns. The first > column has results in every field, but columns 2 and 3 don't have results in > every field. How do I get around this not returning anything when there are > null fields?
coalesce((select ...), '--'); -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
