From: esquel@sommarskog.se   
      
   seb (gekonik@poczta.fm) writes:   
   > i have 2 rows ,who have the same value but in other columnes how to   
   > check diffrence betwwen them   
   >   
   > example:   
   >   
   > 2,'something',something2,null,6   
   > 3,'something5',something8,6,7   
   >   
   > the same value is 6 how to check in wchich columnes is diffrent bettwen   
   > them?   
   >   
      
   I'm not sure that this makes any sense to me. Two rows, the value 6 appears   
   in both, but in different columns? And?   
      
   A table is supposed to model a unique entity and each column is supposed   
   to model a unique attribute of that entity. So if on one row, the column   
   apple has the value 6, and on another row the column orange has the value   
   6, you would still be comparing apples and oranges.   
      
   So maybe your real problem is that your database design is not the best one.   
      
   But apart from that, I don't really understand "wchich columnes is diffrent   
   bettwen them?". In the example above, what output do you want?   
      
      
   --   
   Erland Sommarskog, Stockholm, esquel@sommarskog.se   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)