Hi @ all,
I think thats a bug:
SELECT '#' || '#'
will work but
SELECT '#' || CAST(NULL AS VARCHAR)
will return only empty rows.
My Query looks like this : SELECT field1 || field2 FROM ...
If field2 ISNULL then everything is null. CAST does not help.
thanks for your help
Daniel
______________________________________________________________________________
Die Besten ihrer Klasse! WEB.DE FreeMail (1,7) und WEB.DE Club (1,9) -
bei der Stiftung Warentest - ein Doppelsieg! http://f.web.de/?mc=021184