Daniel Schumann <[EMAIL PROTECTED]> wrote:
i try to combine two fields in a query like: SELECT id, F1||F2 AS
FNew, F3 ... when both fields F1 and F2 got data everything is ok but
if one of the
fields is empty, the whole field FNew is empty :-(
I bet the fields are not empty strings, but NULLs. Try
ifnull(F1, '') || ifnull(F2, '')
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------