hi,

The decode functionality in oracle is something similar to

"if then else...". But what you have stated is "select case...end"

let me clearly explain you a scinario,

table student contains name and total marks

i can say "pass" or "fail" by give a query like

"select name, decode(total > 250, "pass","fail") status from student"

how will u achieve the same scinario in sql-server.

regds

rishi