Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!newsfeed.pionier.net.pl!news.nask.pl!news.nask.org.pl!newsfeed2.atman.pl!newsfeed.atman.pl!.POSTED!not-for-mail
From: seb <gekonik@poczta.fm>
Newsgroups: comp.databases.ms-sqlserver
Subject: compare two rows
Date: Sun, 26 Oct 2014 08:20:49 +0100
Organization: ATMAN - ATM S.A.
Lines: 11
Message-ID: <m2i7bf$9aq$1@node2.news.atman.pl>
NNTP-Posting-Host: 77-92-47-233.cable-modem.tkk.net.pl
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: node2.news.atman.pl 1414308015 9562 77.92.47.233 (26 Oct 2014 07:20:15 GMT)
X-Complaints-To: usenet@atman.pl
NNTP-Posting-Date: Sun, 26 Oct 2014 07:20:15 +0000 (UTC)
User-Agent: Mozilla/5.0 (Windows NT 6.3; WOW64; rv:24.0) Gecko/20100101 Thunderbird/24.6.0
Xref: csiph.com comp.databases.ms-sqlserver:1820

hello
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?