Not able to replace Null string to blank in BIP for teradata query

Question

Summary

Content

Hi ,

In the BI Publisher parameter, for Teradata query, I need to replace NULL character string with blank space

I tried oreplace, but its failing.

erm.empl_full_name in oreplace(:pvar_officer1),'NULL','')

But data model is failing to lead. The requirement is when NULL string is coming for erm.empl_full_name, it should replace by blank & run the query

Venkat Thota - BIP · Answer

please post query then will provide you better one as per business rules. Thanks