This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:27 pm, [email protected] 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]
