I've found that the problem is in the tool i was using (Marathon 1.6). In
flamerobin everything is ok.



Thanks



_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Woody
Sent: Monday, March 31, 2008 12:55 PM
To: firebird-support@yahoogroups.com
Subject: {Disarmed} Re: [firebird-support] Extrange behavior concatenating
fields



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)





[Non-text portions of this message have been removed]