What function to use?

[christimess]

I need to create a derived field that if PERSONAL_DATA.SSN <> AUDIT_PERSONAL.SSN that it will list the AUDIT_PERSONAL.SSN. If it is not applicable (meaning that the 2 SSN's match) then I need it to be a space (' ') so that is is blank. What I don't know is what function to use with this derived field.
Thanks for your help!!

 

[CharlesCook]

DECODE(PERSONAL_DATA.SSN,
AUDIT_PERSONAL.SSN,'',
AUDIT_PERSONAL.SSN)

Take a look at:

http://charlescook.com/PPS/ADP/ReportSmith/PCPW/SQL-Derived-Fields.pps

http://CharlesCook.com

Specializing in ReportSmith Training and Consulting