> In certain queries I wish nulls to be treated as empty strings. For example:
> Select Field1 || ' ' || Field2 AS MyOutputValue;

Try this:

select coalesce (Field1, '') || ' ' || coalesce (Field2, '') AS MyOutputValue;


HTH

Regards

Stefan