Subject Re: [firebird-support] SQL Text joining
Author Robert martin
Great Alexandre

I had never really played with Coalesce before. It has made my SQL and code much simpler as I can now Coalesce the three fields into one and display it!

Coalesce(A, B, C) AS DispText, is what I ended up with :)

p.s. my Brazilian colleague says hello !

Rob Martin
Software Engineer

phone 03 377 0495
fax 03 377 0496
Wild Software Ltd
if the other will be alays null why do you need to concat it ???

try this:

select A || Coalesce(B, '') from MyTable

works on FB 1.5

see you !

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