if then else statement in in database formula tool

[cowannbell]

I have this in my in-database formula tool but it's error with no columns returned.  I assume that I'm not putting it into a format it likes. 

Any help?

[apathetichell · Accepted solution]

In-DB operates using a

CASE WHEN ... THEN ... WHEN... THEN ... ELSE... END

syntax.

[cowannbell]

Thank you so much.

This worked:

CASE
WHEN "PRVDR_ID_NO" <> 0 and "ADDR_NO" = 0 and "RMBRCP_TAXID_NO" = 0 THEN 'PIN_Only'
WHEN "PRVDR_ID_NO" <> 0 and "ADDR_NO" <> 0 and "RMBRCP_TAXID_NO" = 0 THEN 'PIN_Address'
WHEN "PRVDR_ID_NO" <> 0 and "ADDR_NO" <> 0 and "RMBRCP_TAXID_NO" <> 0 THEN 'PIN_Address_Tin'
WHEN "PRVDR_ID_NO" = 0 and "ADDR_NO" <> 0 and "RMBRCP_TAXID_NO" = 0 THEN 'Address_Only'
WHEN "PRVDR_ID_NO" = 0 and "ADDR_NO" <> 0 and "RMBRCP_TAXID_NO" <> 0 THEN 'Address_Tin'
WHEN "PRVDR_ID_NO" = 0 and "ADDR_NO" = 0 and "RMBRCP_TAXID_NO" <> 0 THEN 'Tin_Only'
WHEN "PRVDR_ID_NO" <> 0 and "ADDR_NO" = 0 and "RMBRCP_TAXID_NO" <> 0 THEN 'Tin_PIN'
ELSE ''
END