Elkins Villalona wrote:

> Hello everyone.
>
> I've a table with FIELD_1 and FIELD_2
>
> With two records
>
>
>
> FIELD_1 FIELD_2
>
> 1111111111 JHON DOE
>
> JANE DOE
>
> When I try to concatenate those fields in a query like this
>
> SELECT FIELD_1||FIELD_2 FROM TEST_TABLE
>
>
>
> I just get one record
>
> 11111111111JHON DOE
>

Ah, feel the power of the COALESCE keyword. It allows you to replace a
null field value with another string/value. Check it out and see what
you can do. If you need more help on it, post back with your attempts.

HTH
Woody (TMW)