I want to put an if condition on a field in my SELECT statement as follows:
if (CustomerSub.tr_amount IS NULL)
asr.Total_Due as OmniCurrBal
tr_amount + asr.Total_Due as OmniCurBal
Can this be done? It's giving me a syntax error on the first "IF" line.