Subject [Ticket #118] [firebird-support] Best Practice re null
Author Desarrollo
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.


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