Empty Spaces - Teradata

[NickHoff]

Hello,

I have a field that is not a true NULL, but it includes an empty space in the data set.  However, i'm trying to create an indicator which includes the empty space, but I can't get it to work correctly using the following.  Any ideas?

IF(ContractPUOMCode = 'EA' AND ContractLIUOMCode = 'EA' AND (PriceChargeUOMCode = 'EA' OR ISNULL(PriceChargeUOMCode)= -1 OR PriceChargeUOMCode = '' OR PriceChargeUOMCode = ' '), 'Yes','No')

[NickHoff · Accepted solution]

Apparently just copy and pasting the empty space out of teradata worked:

IF(ContractPUOMCode = 'EA' AND ContractLIUOMCode = 'EA' AND (PriceChargeUOMCode = 'EA' OR PriceChargeUOMCode = '  '), 'Yes','No') AS EAIND,