Decode Function in SQL Server????

[sohaib]

Hi Guys!!

I want to ask a very simple question regarding Decode Function ...Is there any method to use Decode logic in SQL Server 2000....I need this just bcoz i want to get this result ....The result should be like tht;;

In my scenario, i have to find out the persons who have similarity in these fields;
which are Education, Location, Skills...... and the result should display matching Percentage as fully matched result and then till the end but no record shown if anyone of the field not matched....

The result should look like...

Education Location Skills Percent_Matching

Masters England VB.Net 100%
Masters England VB.Net 100%
Masters U.S.A VB.Net 66%
Bachelors England VB.Net 66%
Masters Australia VB.Net 66%
Bachelors Canada VB.Net 33%
Masters France Oracle 33%
Bachelors Germany VB.Net 33%

(8 Rows Selected)

----------------------------------------------------------
Bachelors Sweden Java 0%
Bachelors Pakistan SQL Server 0%

(Not Selected)

plz see this result and telll me how i can make a query on this scenario...

Hope for the positive response from u soon...

ok
Bye