Query question - compare 2 columns

• jenniferhu46

  SSCrazy

  Points: 2990

  More actions

  February 3, 2005 at 1:57 pm

  #66489

  Hi experts,

  Is there any way to add a output column (say column name = 'Diff') which compares epay.EmployID and epay.Socscnum, and show 'Y' if these 2 columns are not the same on this 'Diff' column?

  Thanks.

  ----------------------------------------------------------------

  select upr.LASTNAME+upr.FRSTNAME as EmployeeName,epay.EmployID, epay.Socscnum, epay.Funding_Ind as Status

  from Epay_Fund_Transaction_Table epay left outer join UPR00100 upr on upr.employid=epay.employid

• PW-201837

  SSC-Insane

  Points: 20805

  More actions

  February 3, 2005 at 2:09 pm

  #540518

  See BOL on CASE .. WHEN

  select upr.LASTNAME+upr.FRSTNAME as EmployeeName

    epay.EmployID,

    epay.Socscnum,

    epay.Funding_Ind as Status,

    Case

      When epay.EmployID = epay.Socscnum Then 'N'

      Else 'Y'

    End As Diff

  from Epay_Fund_Transaction_Table epay

  left outer join UPR00100 upr on upr.employid=epay.employid

  You didn't specify what is required if both are Null, which may impact the solution.