[Hsqldb-developers] Concatenating fields

[Nitin U. <nit...@gm...>]

If I concatenate 2 fields:

SELECT field1||'-'||field2 FROM table1,

I get NULL if one of the fields is NULL.

Is this normal? How can I blank NULL fields on SELECT so that on
concatenation, I see the ones that are defined?

I cannot do this in the database because some of them are foreign unique
keys