Decode with NVL derived fields

[RptSm]

I need to create a field that looks at the union code and if its null they put an "N" else "U".

Any suggestions would be appreciated.

 

[CharlesCook]

I think you could do this:

DECODE(THE DATA FIELD HERE,NULL,'N','U')

Make sure you put the data field in.
DO NOT PUT A ' BEFORE AND AFTER NULL .

CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining