Hi,

I have the following query which concatenates FirstName and Surname into a
field called Name :-

SELECT C.ContactID, C.Surname || ', ' || C.FirstName AS Name,
C.StreetAddress, C.Suburb, <various other fields>
FROM  Contacts AS C

However sometimes the FirstName field is blank and in that case the field
Name comes out as blank.  I was expecting Name to be Surname followed by a
comma and a space.   On consulting the H2 SQL syntax, I discovered that a
NULL output is the default action for H2 concatenation, when one field is
NULL.

However I also noticed that choosing, for example, the MySQL mode results
in "Concatenating NULL with another value results in the other value".

My question then is, how could I achieve that result when querying an H2
database?

Thanks

Noel
 --
Noel Lodge
[email protected]

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Reply via email to