On Sat, Dec 11, 2004 at 03:33:07 +0100, Stefan de Konink <[EMAIL PROTECTED]> wrote: > Hi, > > I have a table with some empty colums, if I try to concat my colums to > eachother something strange happens. Rather empty column B produces > virtually no output using the || in the select query. But the half filed > colum A does give the desired output.
Empty strings and NULL values aren't the same thing. You probably either want to store empty strings or use coalesce to change NULL to an empty string before using concatenation, as a NULL concatenated with anything results in NULL. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
