Using INITCAP on a TCC export but fails when the field is blank or empty
In an export file of new hires, we're using the custom function INITCAP on the new hire's name (first, mi, last) and address. It seems there's an issue with INITCAP on the middle initial if it's BLANK or EMPTY. When the configuration file is executed it fails during the soap stripping mode, this is error message; The following error occurred during the export: [itk:ExportQueryExecutionError = ORA-00936: missing expression ]
How can I 1st check if the middle initial is blank/empty and if it is how to skip the initcap function? Also the initial is a UDF.
<quer:projection alias="Initial" xmlns:quer="