From: frank.van.bortel@gmail.com   
      
   krofak wrote:   
   > Today, I noticed different empty string behaviour then I am   
   > used to.   
   >   
   > Before, empty string was treated as null, so statement   
   >   
   > vcResult := 'something' || ''   
   >   
   > would result in vcResult = ''.   
   >   
   > Today, result of this statement was vcResult = 'something'.   
   >   
   > Does anybody know, when (which patchset) did this behaviour   
   > with treating empty strings as null change?   
   >   
   > --   
   > I find myself fascinating.   
   >   
   >   
      
   Not in Oracle... An empty string in Oracle is NULL.   
   NULL concatenated to s string is that string (nothing more,   
   nothing less).   
      
   I find you less fascinating; you obviously post in the   
   wrong group.   
   --   
   Regards,   
   Frank van Bortel   
      
   Top-posting is one way to shut me up...   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)