This is a notification from the Help Desk.

On Mar 07, 2014 @ 03:27 pm, homer@... wrote:
In certain queries I wish nulls to be treated as empty strings. For example:
Select Field1 || ' ' || Field2 AS MyOutputValue;

In this example, I want the value for Field1 to be returned even if Field2 is null.

My first thought is to define a default of '' for the Domains that govern all such fields. At the moment, I can't think of a case where null values would ever be needed in those fields, but my crystal ball is not always accurate. So:

1. Is assigning a default of '' an acceptable practice?
2. Is there a better way to handle this, perhaps within the query SQL?

------
This is an automated response. Your issue has been noted. We'll be in touch soon.



Please reply to this email or visit the URL below with any additional details.

http://DANTOIN:9675/portal/view-help-request/118




[Non-text portions of this message have been removed]