| Subject | Null and Concatenate |
|---|---|
| Author | A6-CMO Philippe Makowski |
| Post date | 2002-10-16T14:17:28Z |
I have to concatenate some fields
SELECT FIELD1 || FIELD2 AS TOT FROM MYTABLE;
But sometimes FIELD1 or FIELD2 is NULL
how can I do for having TOT not NULL in this case ?
SELECT FIELD1 || FIELD2 AS TOT FROM MYTABLE;
But sometimes FIELD1 or FIELD2 is NULL
how can I do for having TOT not NULL in this case ?