L33_WRX

I want to display all NULL values on each column within the table as text 'NULL' instead of being blank. How can I do this, tried case statement but must be easier way...

Cheers


select *
from xior_w_142_cfr_accounts
where XIOR_PROCESS_DATE is null
or XIOR_SOC_SEQNO is null
or XIOR_ACCOUNT_NO is null
or XIOR_SUBACC_NO is null
or XIOR_BOE_TRUE_CAPITAL_BALANCE is null
or XIOR_ACTUAL_ADVANCE is null
or XIOR_INCEPTION_DATE is null
or XIOR_MATURITY_DATE is null
or XIOR_CURR_INTR_RATE is null
or XIOR_CURR_INTR_RATE_TYPE_CODE is null
or XIOR_CURR_INTR_RATE_CAP_RATE is null
or XIOR_CURR_INTR_RATE_FLOOR_RATE is null
or XIOR_CURR_INTR_RATE_REV_DATE is null
or XIOR_CURR_INTR_TERM_BAND_INDEX is null
or XIOR_FINL_INTR_RATE is null
or XIOR_FINL_INTR_RATE_TYPE_CODE is null
or XIOR_FINL_INTR_RATE_CAP_RATE is null
or XIOR_FINL_INTR_RATE_FLOOR_RATE is null
or XIOR_FINL_INTR_TERM_BAND_INDEX is null
or XIOR_LOAN_PURPOSE is null
or XIOR_ORIGINAL_TERM is null
or XIOR_REPAYMENT_METHOD is null
or XIOR_MORTGAGE_CLASS is null
or XIOR_FLEXIBLE_LOAN_MARKER is null
or XIOR_PROVISIONAL_FLAG is null

DJ Dunk

iTrader: (5)

select NVL(XIOR_PROCESS_DATE, 'null')
from xior_w_142_cfr_accounts
where XIOR_PROCESS_DATE is null


. . . would do it, but you'd need to specify each column in the select statement.

L33_WRX

Cheers - done that but forgot the quotes on null - doh! been writing this stuff to long today - need to get home!

DJ Dunk

iTrader: (5)

I start to glaze over after a few hours