Setting a NULL value to an empty string in SQL
Posted on 2016-10-04
I have the following query:
SET Environment.Variables.flag3 =(THE(SELECT ITEM f3.InvCode FROM Database.WMB_DBW_SAP_CODE as f3 WHERE f3.ItemName='presendonadmit' AND f3.DBWCode=InputRoot.MRM.ns:DG1.ns:DG26PresentOnAdmissionInd));
If this SET statement returns a NULL value is their way to change 'f3.DBWCode' field to an empty string ''.
Any assistance is always appreciated.